home *** CD-ROM | disk | FTP | other *** search
| Unknown | 2005-03-24 | 165.8 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 03 01 76 02 23 05 41 53 | 43 49 49 0b 00 f1 00 20 |..v.#.AS|CII.... |
|00000010| 20 20 41 53 43 49 49 28 | 40 76 61 72 7b 73 74 72 | ASCII(|@var{str|
|00000020| 7d 29 0a 52 65 74 75 72 | 6e 73 20 74 68 65 20 6e |}).Retur|ns the n|
|00000030| 75 6d 65 72 69 63 20 76 | 61 6c 75 65 20 6f 66 20 |umeric v|alue of |
|00000040| 74 68 65 20 6c 65 66 74 | 6d 6f 73 74 20 63 68 61 |the left|most cha|
|00000050| 72 61 63 74 65 72 20 6f | 66 20 74 68 65 20 73 74 |racter o|f the st|
|00000060| 72 69 6e 67 0a 40 76 61 | 72 7b 73 74 72 7d 2e 20 |ring.@va|r{str}. |
|00000070| 52 65 74 75 72 6e 73 20 | 30 20 69 66 20 40 76 61 |Returns |0 if @va|
|00000080| 72 7b 73 74 72 7d 20 69 | 73 20 74 68 65 20 65 6d |r{str} i|s the em|
|00000090| 70 74 79 20 73 74 72 69 | 6e 67 2e 20 20 52 65 74 |pty stri|ng. Ret|
|000000a0| 75 72 6e 73 0a 4e 55 4c | 4c 20 69 66 20 40 76 61 |urns.NUL|L if @va|
|000000b0| 72 7b 73 74 72 7d 20 69 | 73 20 4e 55 4c 4c 2e 0a |r{str} i|s NULL..|
|000000c0| 41 53 43 49 49 28 29 20 | 77 6f 72 6b 73 20 66 6f |ASCII() |works fo|
|000000d0| 72 20 63 68 61 72 61 63 | 74 65 72 73 20 77 69 74 |r charac|ters wit|
|000000e0| 68 20 6e 75 6d 65 72 69 | 63 20 76 61 6c 75 65 73 |h numeri|c values|
|000000f0| 20 66 72 6f 6d 20 30 20 | 74 6f 0a 32 35 35 2e 0a | from 0 |to.255..|
|00000100| 77 00 6d 79 73 71 6c 3e | 20 53 45 4c 45 43 54 20 |w.mysql>| SELECT |
|00000110| 41 53 43 49 49 28 27 32 | 27 29 3b 0a 20 20 20 20 |ASCII('2|');. |
|00000120| 20 20 20 20 2d 3e 20 35 | 30 0a 6d 79 73 71 6c 3e | -> 5|0.mysql>|
|00000130| 20 53 45 4c 45 43 54 20 | 41 53 43 49 49 28 32 29 | SELECT |ASCII(2)|
|00000140| 3b 0a 20 20 20 20 20 20 | 20 20 2d 3e 20 35 30 0a |;. | -> 50.|
|00000150| 6d 79 73 71 6c 3e 20 53 | 45 4c 45 43 54 20 41 53 |mysql> S|ELECT AS|
|00000160| 43 49 49 28 27 64 78 27 | 29 3b 0a 20 20 20 20 20 |CII('dx'|);. |
|00000170| 20 20 20 2d 3e 20 31 30 | 30 00 00 00 01 02 2d 22 | -> 10|0.....-"|
|00000180| 01 00 00 00 09 4c 4f 41 | 44 5f 46 49 4c 45 0b 00 |.....LOA|D_FILE..|
|00000190| a9 01 20 20 20 4c 4f 41 | 44 5f 46 49 4c 45 28 40 |.. LOA|D_FILE(@|
|000001a0| 76 61 72 7b 66 69 6c 65 | 5f 6e 61 6d 65 7d 29 0a |var{file|_name}).|
|000001b0| 52 65 61 64 73 20 74 68 | 65 20 66 69 6c 65 20 61 |Reads th|e file a|
|000001c0| 6e 64 20 72 65 74 75 72 | 6e 73 20 74 68 65 20 66 |nd retur|ns the f|
|000001d0| 69 6c 65 20 63 6f 6e 74 | 65 6e 74 73 20 61 73 20 |ile cont|ents as |
|000001e0| 61 20 73 74 72 69 6e 67 | 2e 20 20 54 68 65 20 66 |a string|. The f|
|000001f0| 69 6c 65 0a 6d 75 73 74 | 20 62 65 20 6c 6f 63 61 |ile.must| be loca|
|00000200| 74 65 64 20 6f 6e 20 74 | 68 65 20 73 65 72 76 65 |ted on t|he serve|
|00000210| 72 2c 20 79 6f 75 20 6d | 75 73 74 20 73 70 65 63 |r, you m|ust spec|
|00000220| 69 66 79 20 74 68 65 20 | 66 75 6c 6c 20 70 61 74 |ify the |full pat|
|00000230| 68 6e 61 6d 65 20 74 6f | 20 74 68 65 0a 66 69 6c |hname to| the.fil|
|00000240| 65 2c 20 61 6e 64 20 79 | 6f 75 20 6d 75 73 74 20 |e, and y|ou must |
|00000250| 68 61 76 65 20 74 68 65 | 20 46 49 4c 45 20 70 72 |have the| FILE pr|
|00000260| 69 76 69 6c 65 67 65 2e | 20 20 54 68 65 20 66 69 |ivilege.| The fi|
|00000270| 6c 65 20 6d 75 73 74 0a | 62 65 20 72 65 61 64 61 |le must.|be reada|
|00000280| 62 6c 65 20 62 79 20 61 | 6c 6c 20 61 6e 64 20 62 |ble by a|ll and b|
|00000290| 65 20 73 6d 61 6c 6c 65 | 72 20 74 68 61 6e 20 6d |e smalle|r than m|
|000002a0| 61 78 5f 61 6c 6c 6f 77 | 65 64 5f 70 61 63 6b 65 |ax_allow|ed_packe|
|000002b0| 74 20 62 79 74 65 73 2e | 0a 0a 49 66 20 74 68 65 |t bytes.|..If the|
|000002c0| 20 66 69 6c 65 20 64 6f | 65 73 6e 27 74 20 65 78 | file do|esn't ex|
|000002d0| 69 73 74 20 6f 72 20 63 | 61 6e 6e 6f 74 20 62 65 |ist or c|annot be|
|000002e0| 20 72 65 61 64 20 62 65 | 63 61 75 73 65 20 6f 6e | read be|cause on|
|000002f0| 65 20 6f 66 20 74 68 65 | 20 70 72 65 63 65 64 69 |e of the| precedi|
|00000300| 6e 67 0a 63 6f 6e 64 69 | 74 69 6f 6e 73 20 69 73 |ng.condi|tions is|
|00000310| 20 6e 6f 74 20 73 61 74 | 69 73 66 69 65 64 2c 20 | not sat|isfied, |
|00000320| 74 68 65 20 66 75 6e 63 | 74 69 6f 6e 20 72 65 74 |the func|tion ret|
|00000330| 75 72 6e 73 20 4e 55 4c | 4c 2e 0a 6e 00 6d 79 73 |urns NUL|L..n.mys|
|00000340| 71 6c 3e 20 55 50 44 41 | 54 45 20 40 76 61 72 7b |ql> UPDA|TE @var{|
|00000350| 74 62 6c 5f 6e 61 6d 65 | 7d 0a 20 20 20 20 20 20 |tbl_name|}. |
|00000360| 20 20 20 20 20 53 45 54 | 20 40 76 61 72 7b 62 6c | SET| @var{bl|
|00000370| 6f 62 5f 63 6f 6c 75 6d | 6e 7d 3d 4c 4f 41 44 5f |ob_colum|n}=LOAD_|
|00000380| 46 49 4c 45 28 27 2f 74 | 6d 70 2f 70 69 63 74 75 |FILE('/t|mp/pictu|
|00000390| 72 65 27 29 0a 20 20 20 | 20 20 20 20 20 20 20 20 |re'). | |
|000003a0| 57 48 45 52 45 20 69 64 | 3d 31 3b 00 03 00 5c 00 |WHERE id|=1;...\.|
|000003b0| 32 02 00 00 00 0b 4f 43 | 54 45 54 4c 45 4e 47 54 |2.....OC|TETLENGT|
|000003c0| 48 0b 00 46 00 20 20 20 | 4f 43 54 45 54 5f 4c 45 |H..F. |OCTET_LE|
|000003d0| 4e 47 54 48 28 40 76 61 | 72 7b 73 74 72 7d 29 0a |NGTH(@va|r{str}).|
|000003e0| 0a 4f 43 54 45 54 5f 4c | 45 4e 47 54 48 28 29 20 |.OCTET_L|ENGTH() |
|000003f0| 69 73 20 61 20 73 79 6e | 6f 6e 79 6d 20 66 6f 72 |is a syn|onym for|
|00000400| 20 4c 45 4e 47 54 48 28 | 29 2e 0a 00 03 01 56 02 | LENGTH(|).....V.|
|00000410| 22 03 00 00 00 05 49 4e | 53 54 52 0b 00 db 00 20 |".....IN|STR.... |
|00000420| 20 20 49 4e 53 54 52 28 | 40 76 61 72 7b 73 74 72 | INSTR(|@var{str|
|00000430| 7d 2c 40 76 61 72 7b 73 | 75 62 73 74 72 7d 29 0a |},@var{s|ubstr}).|
|00000440| 52 65 74 75 72 6e 73 20 | 74 68 65 20 70 6f 73 69 |Returns |the posi|
|00000450| 74 69 6f 6e 20 6f 66 20 | 74 68 65 20 66 69 72 73 |tion of |the firs|
|00000460| 74 20 6f 63 63 75 72 72 | 65 6e 63 65 20 6f 66 20 |t occurr|ence of |
|00000470| 73 75 62 73 74 72 69 6e | 67 20 40 76 61 72 7b 73 |substrin|g @var{s|
|00000480| 75 62 73 74 72 7d 20 69 | 6e 0a 73 74 72 69 6e 67 |ubstr} i|n.string|
|00000490| 20 40 76 61 72 7b 73 74 | 72 7d 2e 20 54 68 69 73 | @var{st|r}. This|
|000004a0| 20 69 73 20 74 68 65 20 | 73 61 6d 65 20 61 73 20 | is the |same as |
|000004b0| 74 68 65 20 74 77 6f 2d | 61 72 67 75 6d 65 6e 74 |the two-|argument|
|000004c0| 20 66 6f 72 6d 20 6f 66 | 0a 4c 4f 43 41 54 45 28 | form of|.LOCATE(|
|000004d0| 29 2c 20 65 78 63 65 70 | 74 20 74 68 61 74 20 74 |), excep|t that t|
|000004e0| 68 65 20 61 72 67 75 6d | 65 6e 74 73 20 61 72 65 |he argum|ents are|
|000004f0| 20 73 77 61 70 70 65 64 | 2e 0a 69 00 6d 79 73 71 | swapped|..i.mysq|
|00000500| 6c 3e 20 53 45 4c 45 43 | 54 20 49 4e 53 54 52 28 |l> SELEC|T INSTR(|
|00000510| 27 66 6f 6f 62 61 72 62 | 61 72 27 2c 20 27 62 61 |'foobarb|ar', 'ba|
|00000520| 72 27 29 3b 0a 20 20 20 | 20 20 20 20 20 2d 3e 20 |r');. | -> |
|00000530| 34 0a 6d 79 73 71 6c 3e | 20 53 45 4c 45 43 54 20 |4.mysql>| SELECT |
|00000540| 49 4e 53 54 52 28 27 78 | 62 61 72 27 2c 20 27 66 |INSTR('x|bar', 'f|
|00000550| 6f 6f 62 61 72 27 29 3b | 0a 20 20 20 20 20 20 20 |oobar');|. |
|00000560| 20 2d 3e 20 30 00 00 00 | 03 02 48 00 22 04 00 00 | -> 0...|..H."...|
|00000570| 00 02 49 4e 04 00 d2 01 | 20 20 20 40 76 61 72 7b |..IN....| @var{|
|00000580| 65 78 70 72 7d 20 49 4e | 20 28 40 76 61 72 7b 76 |expr} IN| (@var{v|
|00000590| 61 6c 75 65 7d 2c 2e 2e | 2e 29 0a 52 65 74 75 72 |alue},..|.).Retur|
|000005a0| 6e 73 20 31 20 69 66 20 | 40 76 61 72 7b 65 78 70 |ns 1 if |@var{exp|
|000005b0| 72 7d 20 69 73 20 61 6e | 79 20 6f 66 20 74 68 65 |r} is an|y of the|
|000005c0| 20 76 61 6c 75 65 73 20 | 69 6e 20 74 68 65 20 49 | values |in the I|
|000005d0| 4e 20 6c 69 73 74 2c 0a | 65 6c 73 65 20 72 65 74 |N list,.|else ret|
|000005e0| 75 72 6e 73 20 30 2e 20 | 20 49 66 20 61 6c 6c 20 |urns 0. | If all |
|000005f0| 76 61 6c 75 65 73 20 61 | 72 65 20 63 6f 6e 73 74 |values a|re const|
|00000600| 61 6e 74 73 2c 20 74 68 | 65 79 20 61 72 65 0a 65 |ants, th|ey are.e|
|00000610| 76 61 6c 75 61 74 65 64 | 20 61 63 63 6f 72 64 69 |valuated| accordi|
|00000620| 6e 67 20 74 6f 20 74 68 | 65 20 74 79 70 65 20 6f |ng to th|e type o|
|00000630| 66 20 40 76 61 72 7b 65 | 78 70 72 7d 20 61 6e 64 |f @var{e|xpr} and|
|00000640| 20 73 6f 72 74 65 64 2e | 20 54 68 65 20 73 65 61 | sorted.| The sea|
|00000650| 72 63 68 20 66 6f 72 20 | 74 68 65 0a 69 74 65 6d |rch for |the.item|
|00000660| 20 74 68 65 6e 20 69 73 | 20 64 6f 6e 65 20 75 73 | then is| done us|
|00000670| 69 6e 67 20 61 20 62 69 | 6e 61 72 79 20 73 65 61 |ing a bi|nary sea|
|00000680| 72 63 68 2e 20 54 68 69 | 73 20 6d 65 61 6e 73 20 |rch. Thi|s means |
|00000690| 49 4e 20 69 73 20 76 65 | 72 79 20 71 75 69 63 6b |IN is ve|ry quick|
|000006a0| 0a 69 66 20 74 68 65 20 | 49 4e 20 76 61 6c 75 65 |.if the |IN value|
|000006b0| 20 6c 69 73 74 20 63 6f | 6e 73 69 73 74 73 20 65 | list co|nsists e|
|000006c0| 6e 74 69 72 65 6c 79 20 | 6f 66 20 63 6f 6e 73 74 |ntirely |of const|
|000006d0| 61 6e 74 73 2e 20 20 49 | 66 20 40 76 61 72 7b 65 |ants. I|f @var{e|
|000006e0| 78 70 72 7d 0a 69 73 20 | 61 20 63 61 73 65 2d 73 |xpr}.is |a case-s|
|000006f0| 65 6e 73 69 74 69 76 65 | 20 73 74 72 69 6e 67 20 |ensitive| string |
|00000700| 65 78 70 72 65 73 73 69 | 6f 6e 2c 20 74 68 65 20 |expressi|on, the |
|00000710| 73 74 72 69 6e 67 20 63 | 6f 6d 70 61 72 69 73 6f |string c|ompariso|
|00000720| 6e 20 69 73 20 70 65 72 | 66 6f 72 6d 65 64 20 69 |n is per|formed i|
|00000730| 6e 0a 63 61 73 65 2d 73 | 65 6e 73 69 74 69 76 65 |n.case-s|ensitive|
|00000740| 20 66 61 73 68 69 6f 6e | 2e 0a 67 00 6d 79 73 71 | fashion|..g.mysq|
|00000750| 6c 3e 20 53 45 4c 45 43 | 54 20 32 20 49 4e 20 28 |l> SELEC|T 2 IN (|
|00000760| 30 2c 33 2c 35 2c 27 77 | 65 66 77 66 27 29 3b 0a |0,3,5,'w|efwf');.|
|00000770| 20 20 20 20 20 20 20 20 | 2d 3e 20 30 0a 6d 79 73 | |-> 0.mys|
|00000780| 71 6c 3e 20 53 45 4c 45 | 43 54 20 27 77 65 66 77 |ql> SELE|CT 'wefw|
|00000790| 66 27 20 49 4e 20 28 30 | 2c 33 2c 35 2c 27 77 65 |f' IN (0|,3,5,'we|
|000007a0| 66 77 66 27 29 3b 0a 20 | 20 20 20 20 20 20 20 2d |fwf');. | -|
|000007b0| 3e 20 31 00 03 00 76 02 | 32 05 00 00 00 0c 43 55 |> 1...v.|2.....CU|
|000007c0| 52 52 45 4e 54 5f 54 49 | 4d 45 0f 00 5f 00 20 20 |RRENT_TI|ME.._. |
|000007d0| 20 43 55 52 52 45 4e 54 | 5f 54 49 4d 45 0a 20 20 | CURRENT|_TIME. |
|000007e0| 20 43 55 52 52 45 4e 54 | 5f 54 49 4d 45 28 29 0a | CURRENT|_TIME().|
|000007f0| 0a 43 55 52 52 45 4e 54 | 5f 54 49 4d 45 20 61 6e |.CURRENT|_TIME an|
|00000800| 64 20 43 55 52 52 45 4e | 54 5f 54 49 4d 45 28 29 |d CURREN|T_TIME()|
|00000810| 20 61 72 65 20 73 79 6e | 6f 6e 79 6d 73 20 66 6f | are syn|onyms fo|
|00000820| 72 0a 43 55 52 54 49 4d | 45 28 29 2e 0a 00 00 00 |r.CURTIM|E().....|
|00000830| 03 02 5a 02 22 06 00 00 | 00 0b 4d 42 52 43 4f 4e |..Z."...|..MBRCON|
|00000840| 54 41 49 4e 53 06 00 ac | 00 20 20 20 4d 42 52 43 |TAINS...|. MBRC|
|00000850| 6f 6e 74 61 69 6e 73 28 | 40 76 61 72 7b 67 31 7d |ontains(|@var{g1}|
|00000860| 2c 40 76 61 72 7b 67 32 | 7d 29 0a 52 65 74 75 72 |,@var{g2|}).Retur|
|00000870| 6e 73 20 31 20 6f 72 20 | 30 20 74 6f 20 69 6e 64 |ns 1 or |0 to ind|
|00000880| 69 63 61 74 65 20 77 68 | 65 74 68 65 72 20 6f 72 |icate wh|ether or|
|00000890| 20 6e 6f 74 20 74 68 65 | 20 4d 69 6e 69 6d 75 6d | not the| Minimum|
|000008a0| 20 42 6f 75 6e 64 69 6e | 67 20 52 65 63 74 61 6e | Boundin|g Rectan|
|000008b0| 67 6c 65 20 6f 66 0a 40 | 76 61 72 7b 67 31 7d 20 |gle of.@|var{g1} |
|000008c0| 63 6f 6e 74 61 69 6e 73 | 20 74 68 65 20 4d 69 6e |contains| the Min|
|000008d0| 69 6d 75 6d 20 42 6f 75 | 6e 64 69 6e 67 20 52 65 |imum Bou|nding Re|
|000008e0| 63 74 61 6e 67 6c 65 20 | 6f 66 20 40 76 61 72 7b |ctangle |of @var{|
|000008f0| 67 32 7d 2e 0a 96 01 6d | 79 73 71 6c 3e 20 53 45 |g2}....m|ysql> SE|
|00000900| 54 20 40 67 31 20 3d 20 | 47 65 6f 6d 46 72 6f 6d |T @g1 = |GeomFrom|
|00000910| 54 65 78 74 28 27 50 6f | 6c 79 67 6f 6e 28 28 30 |Text('Po|lygon((0|
|00000920| 20 30 2c 30 20 33 2c 33 | 20 33 2c 33 20 30 2c 30 | 0,0 3,3| 3,3 0,0|
|00000930| 20 30 29 29 27 29 3b 0a | 6d 79 73 71 6c 3e 20 53 | 0))');.|mysql> S|
|00000940| 45 54 20 40 67 32 20 3d | 20 47 65 6f 6d 46 72 6f |ET @g2 =| GeomFro|
|00000950| 6d 54 65 78 74 28 27 50 | 6f 69 6e 74 28 31 20 31 |mText('P|oint(1 1|
|00000960| 29 27 29 3b 0a 6d 79 73 | 71 6c 3e 20 53 45 4c 45 |)');.mys|ql> SELE|
|00000970| 43 54 20 4d 42 52 43 6f | 6e 74 61 69 6e 73 28 40 |CT MBRCo|ntains(@|
|00000980| 67 31 2c 40 67 32 29 2c | 20 4d 42 52 43 6f 6e 74 |g1,@g2),| MBRCont|
|00000990| 61 69 6e 73 28 40 67 32 | 2c 40 67 31 29 3b 0a 2d |ains(@g2|,@g1);.-|
|000009a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000009b0| 2d 2d 2d 2d 2d 2b 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |-----+--|--------|
|000009c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2b 0a 7c 20 |--------|----+.| |
|000009d0| 4d 42 52 43 6f 6e 74 61 | 69 6e 73 28 40 67 31 2c |MBRConta|ins(@g1,|
|000009e0| 40 67 32 29 20 7c 20 4d | 42 52 43 6f 6e 74 61 69 |@g2) | M|BRContai|
|000009f0| 6e 73 28 40 67 32 2c 40 | 67 31 29 20 7c 0a 2b 2d |ns(@g2,@|g1) |.+-|
|00000a00| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000a10| 2d 2d 2d 2d 2d 2b 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |-----+--|--------|
|00000a20| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2b 0a 7c 20 |--------|----+.| |
|00000a30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000a40| 20 20 20 31 20 7c 20 20 | 20 20 20 20 20 20 20 20 | 1 | | |
|00000a50| 20 20 20 20 20 20 20 20 | 20 20 30 20 7c 0a 2b 2d | | 0 |.+-|
|00000a60| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000a70| 2d 2d 2d 2d 2d 2b 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |-----+--|--------|
|00000a80| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2b 00 00 00 |--------|----+...|
|00000a90| 03 00 b7 01 22 07 00 00 | 00 0d 44 41 54 45 20 46 |...."...|..DATE F|
|00000aa0| 55 4e 43 54 49 4f 4e 0f | 00 5b 00 20 20 20 44 41 |UNCTION.|.[. DA|
|00000ab0| 54 45 28 40 76 61 72 7b | 65 78 70 72 7d 29 0a 0a |TE(@var{|expr})..|
|00000ac0| 45 78 74 72 61 63 74 73 | 20 74 68 65 20 64 61 74 |Extracts| the dat|
|00000ad0| 65 20 70 61 72 74 20 6f | 66 20 74 68 65 20 64 61 |e part o|f the da|
|00000ae0| 74 65 20 6f 72 20 64 61 | 74 65 74 69 6d 65 20 65 |te or da|tetime e|
|00000af0| 78 70 72 65 73 73 69 6f | 6e 20 40 76 61 72 7b 65 |xpressio|n @var{e|
|00000b00| 78 70 72 7d 2e 0a 42 00 | 6d 79 73 71 6c 3e 20 53 |xpr}..B.|mysql> S|
|00000b10| 45 4c 45 43 54 20 44 41 | 54 45 28 27 32 30 30 33 |ELECT DA|TE('2003|
|00000b20| 2d 31 32 2d 33 31 20 30 | 31 3a 30 32 3a 30 33 27 |-12-31 0|1:02:03'|
|00000b30| 29 3b 0a 20 20 20 20 20 | 20 20 20 2d 3e 20 27 32 |);. | -> '2|
|00000b40| 30 30 33 2d 31 32 2d 33 | 31 27 00 00 03 04 fe 02 |003-12-3|1'......|
|00000b50| 22 08 00 00 00 05 4d 45 | 52 47 45 13 00 eb 02 0a |".....ME|RGE.....|
|00000b60| 40 6d 65 6e 75 0a 2a 20 | 4d 45 52 47 45 20 74 61 |@menu.* |MERGE ta|
|00000b70| 62 6c 65 20 70 72 6f 62 | 6c 65 6d 73 3a 3a 20 20 |ble prob|lems:: |
|00000b80| 20 20 20 20 20 20 4d 45 | 52 47 45 20 54 61 62 6c | ME|RGE Tabl|
|00000b90| 65 20 50 72 6f 62 6c 65 | 6d 73 0a 40 65 6e 64 20 |e Proble|ms.@end |
|00000ba0| 6d 65 6e 75 0a 0a 54 68 | 65 20 4d 45 52 47 45 20 |menu..Th|e MERGE |
|00000bb0| 73 74 6f 72 61 67 65 20 | 65 6e 67 69 6e 65 20 77 |storage |engine w|
|00000bc0| 61 73 20 69 6e 74 72 6f | 64 75 63 65 64 20 69 6e |as intro|duced in|
|00000bd0| 20 4d 79 53 51 4c 20 33 | 2e 32 33 2e 32 35 2e 20 | MySQL 3|.23.25. |
|00000be0| 49 74 0a 69 73 20 61 6c | 73 6f 20 6b 6e 6f 77 6e |It.is al|so known|
|00000bf0| 20 61 73 20 74 68 65 20 | 4d 52 47 5f 4d 79 49 53 | as the |MRG_MyIS|
|00000c00| 41 4d 20 65 6e 67 69 6e | 65 2e 20 54 68 65 20 63 |AM engin|e. The c|
|00000c10| 6f 64 65 20 69 73 20 6e | 6f 77 20 72 65 61 73 6f |ode is n|ow reaso|
|00000c20| 6e 61 62 6c 79 0a 73 74 | 61 62 6c 65 2e 0a 0a 41 |nably.st|able...A|
|00000c30| 20 4d 45 52 47 45 20 74 | 61 62 6c 65 20 69 73 20 | MERGE t|able is |
|00000c40| 61 20 63 6f 6c 6c 65 63 | 74 69 6f 6e 20 6f 66 20 |a collec|tion of |
|00000c50| 69 64 65 6e 74 69 63 61 | 6c 20 4d 79 49 53 41 4d |identica|l MyISAM|
|00000c60| 20 74 61 62 6c 65 73 20 | 74 68 61 74 0a 63 61 6e | tables |that.can|
|00000c70| 20 62 65 20 75 73 65 64 | 20 61 73 20 6f 6e 65 2e | be used| as one.|
|00000c80| 20 20 60 60 49 64 65 6e | 74 69 63 61 6c 27 27 20 | ``Iden|tical'' |
|00000c90| 6d 65 61 6e 73 20 74 68 | 61 74 20 61 6c 6c 20 74 |means th|at all t|
|00000ca0| 61 62 6c 65 73 20 68 61 | 76 65 0a 69 64 65 6e 74 |ables ha|ve.ident|
|00000cb0| 69 63 61 6c 20 63 6f 6c | 75 6d 6e 20 61 6e 64 20 |ical col|umn and |
|00000cc0| 69 6e 64 65 78 20 69 6e | 66 6f 72 6d 61 74 69 6f |index in|formatio|
|00000cd0| 6e 2e 20 20 59 6f 75 20 | 63 61 6e 27 74 20 6d 65 |n. You |can't me|
|00000ce0| 72 67 65 20 74 61 62 6c | 65 73 20 69 6e 20 77 68 |rge tabl|es in wh|
|00000cf0| 69 63 68 20 74 68 65 0a | 63 6f 6c 75 6d 6e 73 20 |ich the.|columns |
|00000d00| 61 72 65 20 6c 69 73 74 | 65 64 20 69 6e 20 61 20 |are list|ed in a |
|00000d10| 64 69 66 66 65 72 65 6e | 74 20 6f 72 64 65 72 2c |differen|t order,|
|00000d20| 20 64 6f 6e 27 74 20 68 | 61 76 65 20 65 78 61 63 | don't h|ave exac|
|00000d30| 74 6c 79 20 74 68 65 20 | 73 61 6d 65 20 63 6f 6c |tly the |same col|
|00000d40| 75 6d 6e 73 2c 20 6f 72 | 0a 68 61 76 65 20 74 68 |umns, or|.have th|
|00000d50| 65 20 69 6e 64 65 78 65 | 73 20 69 6e 20 64 69 66 |e indexe|s in dif|
|00000d60| 66 65 72 65 6e 74 20 6f | 72 64 65 72 2e 20 20 48 |ferent o|rder. H|
|00000d70| 6f 77 65 76 65 72 2c 20 | 61 6e 79 20 6f 72 20 61 |owever, |any or a|
|00000d80| 6c 6c 20 6f 66 20 74 68 | 65 20 74 61 62 6c 65 73 |ll of th|e tables|
|00000d90| 20 63 61 6e 20 62 65 0a | 63 6f 6d 70 72 65 73 73 | can be.|compress|
|00000da0| 65 64 20 77 69 74 68 20 | 40 63 6f 6d 6d 61 6e 64 |ed with |@command|
|00000db0| 7b 6d 79 69 73 61 6d 70 | 61 63 6b 7d 2e 0a 53 65 |{myisamp|ack}..Se|
|00000dc0| 65 20 61 6c 73 6f 20 3a | 20 5b 6d 79 69 73 61 6d |e also :| [myisam|
|00000dd0| 70 61 63 6b 2c 20 2c 20 | 40 63 6f 6d 6d 61 6e 64 |pack, , |@command|
|00000de0| 7b 6d 79 69 73 61 6d 70 | 61 63 6b 5d 7d 2e 0a 44 |{myisamp|ack]}..D|
|00000df0| 69 66 66 65 72 65 6e 63 | 65 73 20 69 6e 20 74 61 |ifferenc|es in ta|
|00000e00| 62 6c 65 20 6f 70 74 69 | 6f 6e 73 20 73 75 63 68 |ble opti|ons such|
|00000e10| 20 61 73 20 41 56 47 5f | 52 4f 57 5f 4c 45 4e 47 | as AVG_|ROW_LENG|
|00000e20| 54 48 2c 20 4d 41 58 5f | 52 4f 57 53 2c 0a 6f 72 |TH, MAX_|ROWS,.or|
|00000e30| 20 50 41 43 4b 5f 4b 45 | 59 53 20 64 6f 20 6e 6f | PACK_KE|YS do no|
|00000e40| 74 20 6d 61 74 74 65 72 | 2e 0a 01 02 6d 79 73 71 |t matter|....mysq|
|00000e50| 6c 3e 20 43 52 45 41 54 | 45 20 54 41 42 4c 45 20 |l> CREAT|E TABLE |
|00000e60| 74 31 20 28 0a 20 20 20 | 20 2d 3e 20 20 20 20 61 |t1 (. | -> a|
|00000e70| 20 49 4e 54 20 4e 4f 54 | 20 4e 55 4c 4c 20 41 55 | INT NOT| NULL AU|
|00000e80| 54 4f 5f 49 4e 43 52 45 | 4d 45 4e 54 20 50 52 49 |TO_INCRE|MENT PRI|
|00000e90| 4d 41 52 59 20 4b 45 59 | 2c 0a 20 20 20 20 2d 3e |MARY KEY|,. ->|
|00000ea0| 20 20 20 20 6d 65 73 73 | 61 67 65 20 43 48 41 52 | mess|age CHAR|
|00000eb0| 28 32 30 29 29 3b 0a 6d | 79 73 71 6c 3e 20 43 52 |(20));.m|ysql> CR|
|00000ec0| 45 41 54 45 20 54 41 42 | 4c 45 20 74 32 20 28 0a |EATE TAB|LE t2 (.|
|00000ed0| 20 20 20 20 2d 3e 20 20 | 20 20 61 20 49 4e 54 20 | -> | a INT |
|00000ee0| 4e 4f 54 20 4e 55 4c 4c | 20 41 55 54 4f 5f 49 4e |NOT NULL| AUTO_IN|
|00000ef0| 43 52 45 4d 45 4e 54 20 | 50 52 49 4d 41 52 59 20 |CREMENT |PRIMARY |
|00000f00| 4b 45 59 2c 0a 20 20 20 | 20 2d 3e 20 20 20 20 6d |KEY,. | -> m|
|00000f10| 65 73 73 61 67 65 20 43 | 48 41 52 28 32 30 29 29 |essage C|HAR(20))|
|00000f20| 3b 0a 6d 79 73 71 6c 3e | 20 49 4e 53 45 52 54 20 |;.mysql>| INSERT |
|00000f30| 49 4e 54 4f 20 74 31 20 | 28 6d 65 73 73 61 67 65 |INTO t1 |(message|
|00000f40| 29 20 56 41 4c 55 45 53 | 20 28 27 54 65 73 74 69 |) VALUES| ('Testi|
|00000f50| 6e 67 27 29 2c 28 27 74 | 61 62 6c 65 27 29 2c 28 |ng'),('t|able'),(|
|00000f60| 27 74 31 27 29 3b 0a 6d | 79 73 71 6c 3e 20 49 4e |'t1');.m|ysql> IN|
|00000f70| 53 45 52 54 20 49 4e 54 | 4f 20 74 32 20 28 6d 65 |SERT INT|O t2 (me|
|00000f80| 73 73 61 67 65 29 20 56 | 41 4c 55 45 53 20 28 27 |ssage) V|ALUES ('|
|00000f90| 54 65 73 74 69 6e 67 27 | 29 2c 28 27 74 61 62 6c |Testing'|),('tabl|
|00000fa0| 65 27 29 2c 28 27 74 32 | 27 29 3b 0a 6d 79 73 71 |e'),('t2|');.mysq|
|00000fb0| 6c 3e 20 43 52 45 41 54 | 45 20 54 41 42 4c 45 20 |l> CREAT|E TABLE |
|00000fc0| 74 6f 74 61 6c 20 28 0a | 20 20 20 20 2d 3e 20 20 |total (.| -> |
|00000fd0| 20 20 61 20 49 4e 54 20 | 4e 4f 54 20 4e 55 4c 4c | a INT |NOT NULL|
|00000fe0| 20 41 55 54 4f 5f 49 4e | 43 52 45 4d 45 4e 54 2c | AUTO_IN|CREMENT,|
|00000ff0| 0a 20 20 20 20 2d 3e 20 | 20 20 20 6d 65 73 73 61 |. -> | messa|
|00001000| 67 65 20 43 48 41 52 28 | 32 30 29 2c 20 49 4e 44 |ge CHAR(|20), IND|
|00001010| 45 58 28 61 29 29 0a 20 | 20 20 20 2d 3e 20 20 20 |EX(a)). | -> |
|00001020| 20 54 59 50 45 3d 4d 45 | 52 47 45 20 55 4e 49 4f | TYPE=ME|RGE UNIO|
|00001030| 4e 3d 28 74 31 2c 74 32 | 29 20 49 4e 53 45 52 54 |N=(t1,t2|) INSERT|
|00001040| 5f 4d 45 54 48 4f 44 3d | 4c 41 53 54 3b 00 00 00 |_METHOD=|LAST;...|
|00001050| 03 00 7f 01 32 09 00 00 | 00 06 57 49 54 48 49 4e |....2...|..WITHIN|
|00001060| 19 00 6e 00 20 20 20 57 | 69 74 68 69 6e 28 40 76 |..n. W|ithin(@v|
|00001070| 61 72 7b 67 31 7d 2c 40 | 76 61 72 7b 67 32 7d 29 |ar{g1},@|var{g2})|
|00001080| 0a 52 65 74 75 72 6e 73 | 20 31 20 6f 72 20 30 20 |.Returns| 1 or 0 |
|00001090| 74 6f 20 69 6e 64 69 63 | 61 74 65 20 77 68 65 74 |to indic|ate whet|
|000010a0| 68 65 72 20 6f 72 20 6e | 6f 74 20 40 76 61 72 7b |her or n|ot @var{|
|000010b0| 67 31 7d 20 69 73 20 73 | 70 61 74 69 61 6c 6c 79 |g1} is s|patially|
|000010c0| 20 77 69 74 68 69 6e 0a | 40 76 61 72 7b 67 32 7d | within.|@var{g2}|
|000010d0| 2e 0a 00 00 03 00 bb 01 | 32 0a 00 00 00 0c 4d 4c |........|2.....ML|
|000010e0| 49 4e 45 46 52 4f 4d 57 | 4b 42 05 00 a4 00 20 20 |INEFROMW|KB.... |
|000010f0| 20 4d 4c 69 6e 65 46 72 | 6f 6d 57 4b 42 28 40 76 | MLineFr|omWKB(@v|
|00001100| 61 72 7b 77 6b 62 7d 5b | 2c 40 76 61 72 7b 73 72 |ar{wkb}[|,@var{sr|
|00001110| 69 64 7d 5d 29 0a 20 20 | 20 4d 75 6c 74 69 4c 69 |id}]). | MultiLi|
|00001120| 6e 65 53 74 72 69 6e 67 | 46 72 6f 6d 57 4b 42 28 |neString|FromWKB(|
|00001130| 40 76 61 72 7b 77 6b 62 | 7d 5b 2c 40 76 61 72 7b |@var{wkb|}[,@var{|
|00001140| 73 72 69 64 7d 5d 29 0a | 43 6f 6e 73 74 72 75 63 |srid}]).|Construc|
|00001150| 74 73 20 61 20 4d 55 4c | 54 49 4c 49 4e 45 53 54 |ts a MUL|TILINEST|
|00001160| 52 49 4e 47 20 76 61 6c | 75 65 20 75 73 69 6e 67 |RING val|ue using|
|00001170| 20 69 74 73 20 57 4b 42 | 20 72 65 70 72 65 73 65 | its WKB| represe|
|00001180| 6e 74 61 74 69 6f 6e 20 | 61 6e 64 20 53 52 49 44 |ntation |and SRID|
|00001190| 2e 0a 00 00 03 02 5f 01 | 22 0b 00 00 00 04 54 52 |......_.|".....TR|
|000011a0| 49 4d 0b 00 53 01 20 20 | 20 54 52 49 4d 28 5b 7b |IM..S. | TRIM([{|
|000011b0| 42 4f 54 48 20 7c 20 4c | 45 41 44 49 4e 47 20 7c |BOTH | L|EADING ||
|000011c0| 20 54 52 41 49 4c 49 4e | 47 7d 20 5b 40 76 61 72 | TRAILIN|G} [@var|
|000011d0| 7b 72 65 6d 73 74 72 7d | 5d 20 46 52 4f 4d 5d 20 |{remstr}|] FROM] |
|000011e0| 40 76 61 72 7b 73 74 72 | 7d 29 0a 20 20 20 54 52 |@var{str|}). TR|
|000011f0| 49 4d 28 40 76 61 72 7b | 72 65 6d 73 74 72 7d 20 |IM(@var{|remstr} |
|00001200| 46 52 4f 4d 5d 20 40 76 | 61 72 7b 73 74 72 7d 29 |FROM] @v|ar{str})|
|00001210| 0a 52 65 74 75 72 6e 73 | 20 74 68 65 20 73 74 72 |.Returns| the str|
|00001220| 69 6e 67 20 40 76 61 72 | 7b 73 74 72 7d 20 77 69 |ing @var|{str} wi|
|00001230| 74 68 20 61 6c 6c 20 40 | 76 61 72 7b 72 65 6d 73 |th all @|var{rems|
|00001240| 74 72 7d 20 70 72 65 66 | 69 78 65 73 20 61 6e 64 |tr} pref|ixes and|
|00001250| 2f 6f 72 20 73 75 66 66 | 69 78 65 73 0a 72 65 6d |/or suff|ixes.rem|
|00001260| 6f 76 65 64 2e 20 49 66 | 20 6e 6f 6e 65 20 6f 66 |oved. If| none of|
|00001270| 20 74 68 65 20 73 70 65 | 63 69 66 69 65 72 73 20 | the spe|cifiers |
|00001280| 42 4f 54 48 2c 20 4c 45 | 41 44 49 4e 47 2c 20 6f |BOTH, LE|ADING, o|
|00001290| 72 0a 54 52 41 49 4c 49 | 4e 47 20 69 73 20 67 69 |r.TRAILI|NG is gi|
|000012a0| 76 65 6e 2c 20 42 4f 54 | 48 20 69 73 20 61 73 73 |ven, BOT|H is ass|
|000012b0| 75 6d 65 64 2e 20 49 66 | 20 40 76 61 72 7b 72 65 |umed. If| @var{re|
|000012c0| 6d 73 74 72 7d 20 69 73 | 20 6f 70 74 69 6f 6e 61 |mstr} is| optiona|
|000012d0| 6c 0a 61 6e 64 20 6e 6f | 74 20 73 70 65 63 69 66 |l.and no|t specif|
|000012e0| 69 65 64 2c 20 73 70 61 | 63 65 73 20 61 72 65 20 |ied, spa|ces are |
|000012f0| 72 65 6d 6f 76 65 64 2e | 0a fb 00 6d 79 73 71 6c |removed.|...mysql|
|00001300| 3e 20 53 45 4c 45 43 54 | 20 54 52 49 4d 28 27 20 |> SELECT| TRIM(' |
|00001310| 20 62 61 72 20 20 20 27 | 29 3b 0a 20 20 20 20 20 | bar '|);. |
|00001320| 20 20 20 2d 3e 20 27 62 | 61 72 27 0a 6d 79 73 71 | -> 'b|ar'.mysq|
|00001330| 6c 3e 20 53 45 4c 45 43 | 54 20 54 52 49 4d 28 4c |l> SELEC|T TRIM(L|
|00001340| 45 41 44 49 4e 47 20 27 | 78 27 20 46 52 4f 4d 20 |EADING '|x' FROM |
|00001350| 27 78 78 78 62 61 72 78 | 78 78 27 29 3b 0a 20 20 |'xxxbarx|xx');. |
|00001360| 20 20 20 20 20 20 2d 3e | 20 27 62 61 72 78 78 78 | ->| 'barxxx|
|00001370| 27 0a 6d 79 73 71 6c 3e | 20 53 45 4c 45 43 54 20 |'.mysql>| SELECT |
|00001380| 54 52 49 4d 28 42 4f 54 | 48 20 27 78 27 20 46 52 |TRIM(BOT|H 'x' FR|
|00001390| 4f 4d 20 27 78 78 78 62 | 61 72 78 78 78 27 29 3b |OM 'xxxb|arxxx');|
|000013a0| 0a 20 20 20 20 20 20 20 | 20 2d 3e 20 27 62 61 72 |. | -> 'bar|
|000013b0| 27 0a 6d 79 73 71 6c 3e | 20 53 45 4c 45 43 54 20 |'.mysql>| SELECT |
|000013c0| 54 52 49 4d 28 54 52 41 | 49 4c 49 4e 47 20 27 78 |TRIM(TRA|ILING 'x|
|000013d0| 79 7a 27 20 46 52 4f 4d | 20 27 62 61 72 78 78 79 |yz' FROM| 'barxxy|
|000013e0| 7a 27 29 3b 0a 20 20 20 | 20 20 20 20 20 2d 3e 20 |z');. | -> |
|000013f0| 27 62 61 72 78 27 00 00 | 03 01 67 01 22 0c 00 00 |'barx'..|..g."...|
|00001400| 00 04 4c 50 41 44 0b 00 | f4 00 20 20 20 4c 50 41 |..LPAD..|.. LPA|
|00001410| 44 28 40 76 61 72 7b 73 | 74 72 7d 2c 40 76 61 72 |D(@var{s|tr},@var|
|00001420| 7b 6c 65 6e 7d 2c 40 76 | 61 72 7b 70 61 64 73 74 |{len},@v|ar{padst|
|00001430| 72 7d 29 0a 52 65 74 75 | 72 6e 73 20 74 68 65 20 |r}).Retu|rns the |
|00001440| 73 74 72 69 6e 67 20 40 | 76 61 72 7b 73 74 72 7d |string @|var{str}|
|00001450| 2c 20 6c 65 66 74 2d 70 | 61 64 64 65 64 20 77 69 |, left-p|added wi|
|00001460| 74 68 20 74 68 65 20 73 | 74 72 69 6e 67 20 40 76 |th the s|tring @v|
|00001470| 61 72 7b 70 61 64 73 74 | 72 7d 0a 74 6f 20 61 20 |ar{padst|r}.to a |
|00001480| 6c 65 6e 67 74 68 20 6f | 66 20 40 76 61 72 7b 6c |length o|f @var{l|
|00001490| 65 6e 7d 20 63 68 61 72 | 61 63 74 65 72 73 2e 20 |en} char|acters. |
|000014a0| 49 66 20 40 76 61 72 7b | 73 74 72 7d 20 69 73 20 |If @var{|str} is |
|000014b0| 6c 6f 6e 67 65 72 0a 74 | 68 61 6e 20 40 76 61 72 |longer.t|han @var|
|000014c0| 7b 6c 65 6e 7d 2c 20 74 | 68 65 20 72 65 74 75 72 |{len}, t|he retur|
|000014d0| 6e 20 76 61 6c 75 65 20 | 69 73 20 73 68 6f 72 74 |n value |is short|
|000014e0| 65 6e 65 64 20 74 6f 20 | 40 76 61 72 7b 6c 65 6e |ened to |@var{len|
|000014f0| 7d 20 63 68 61 72 61 63 | 74 65 72 73 2e 0a 62 00 |} charac|ters..b.|
|00001500| 6d 79 73 71 6c 3e 20 53 | 45 4c 45 43 54 20 4c 50 |mysql> S|ELECT LP|
|00001510| 41 44 28 27 68 69 27 2c | 34 2c 27 3f 3f 27 29 3b |AD('hi',|4,'??');|
|00001520| 0a 20 20 20 20 20 20 20 | 20 2d 3e 20 27 3f 3f 68 |. | -> '??h|
|00001530| 69 27 0a 6d 79 73 71 6c | 3e 20 53 45 4c 45 43 54 |i'.mysql|> SELECT|
|00001540| 20 4c 50 41 44 28 27 68 | 69 27 2c 31 2c 27 3f 3f | LPAD('h|i',1,'??|
|00001550| 27 29 3b 0a 20 20 20 20 | 20 20 20 20 2d 3e 20 27 |');. | -> '|
|00001560| 68 27 00 00 03 00 7c 00 | 32 0d 00 00 00 08 54 49 |h'....|.|2.....TI|
|00001570| 4e 59 42 4c 4f 42 01 00 | 69 00 20 20 20 54 49 4e |NYBLOB..|i. TIN|
|00001580| 59 42 4c 4f 42 0a 20 20 | 20 54 49 4e 59 54 45 58 |YBLOB. | TINYTEX|
|00001590| 54 0a 0a 41 20 42 4c 4f | 42 20 6f 72 20 54 45 58 |T..A BLO|B or TEX|
|000015a0| 54 20 63 6f 6c 75 6d 6e | 20 77 69 74 68 20 61 20 |T column| with a |
|000015b0| 6d 61 78 69 6d 75 6d 20 | 6c 65 6e 67 74 68 20 6f |maximum |length o|
|000015c0| 66 20 32 35 35 20 28 32 | 5e 38 0a 40 6d 69 6e 75 |f 255 (2|^8.@minu|
|000015d0| 73 7b 7d 20 31 29 0a 63 | 68 61 72 61 63 74 65 72 |s{} 1).c|haracter|
|000015e0| 73 2e 0a 00 01 03 85 32 | 0e 00 00 00 07 53 50 41 |s......2|.....SPA|
|000015f0| 54 49 41 4c 18 00 73 03 | 4d 79 53 51 4c 20 63 61 |TIAL..s.|MySQL ca|
|00001600| 6e 20 63 72 65 61 74 65 | 20 73 70 61 74 69 61 6c |n create| spatial|
|00001610| 20 69 6e 64 65 78 65 73 | 20 75 73 69 6e 67 20 73 | indexes| using s|
|00001620| 79 6e 74 61 78 20 73 69 | 6d 69 6c 61 72 20 74 6f |yntax si|milar to|
|00001630| 20 74 68 61 74 20 66 6f | 72 20 63 72 65 61 74 69 | that fo|r creati|
|00001640| 6e 67 0a 72 65 67 75 6c | 61 72 20 69 6e 64 65 78 |ng.regul|ar index|
|00001650| 65 73 2c 20 62 75 74 20 | 65 78 74 65 6e 64 65 64 |es, but |extended|
|00001660| 20 77 69 74 68 20 74 68 | 65 20 53 50 41 54 49 41 | with th|e SPATIA|
|00001670| 4c 20 6b 65 79 77 6f 72 | 64 2e 0a 53 70 61 74 69 |L keywor|d..Spati|
|00001680| 61 6c 20 63 6f 6c 75 6d | 6e 73 20 74 68 61 74 20 |al colum|ns that |
|00001690| 61 72 65 20 69 6e 64 65 | 78 65 64 20 63 75 72 72 |are inde|xed curr|
|000016a0| 65 6e 74 6c 79 20 6d 75 | 73 74 20 62 65 20 64 65 |ently mu|st be de|
|000016b0| 63 6c 61 72 65 64 20 4e | 4f 54 20 4e 55 4c 4c 2e |clared N|OT NULL.|
|000016c0| 0a 54 68 65 20 66 6f 6c | 6c 6f 77 69 6e 67 20 65 |.The fol|lowing e|
|000016d0| 78 61 6d 70 6c 65 73 20 | 64 65 6d 6f 6e 73 74 72 |xamples |demonstr|
|000016e0| 61 74 65 20 68 6f 77 20 | 74 6f 20 63 72 65 61 74 |ate how |to creat|
|000016f0| 65 20 73 70 61 74 69 61 | 6c 20 69 6e 64 65 78 65 |e spatia|l indexe|
|00001700| 73 2e 0a 0a 0a 20 20 20 | 57 69 74 68 20 43 52 45 |s.... |With CRE|
|00001710| 41 54 45 20 54 41 42 4c | 45 3a 0a 0a 6d 79 73 71 |ATE TABL|E:..mysq|
|00001720| 6c 3e 20 43 52 45 41 54 | 45 20 54 41 42 4c 45 20 |l> CREAT|E TABLE |
|00001730| 67 65 6f 6d 20 28 67 20 | 47 45 4f 4d 45 54 52 59 |geom (g |GEOMETRY|
|00001740| 20 4e 4f 54 20 4e 55 4c | 4c 2c 20 53 50 41 54 49 | NOT NUL|L, SPATI|
|00001750| 41 4c 20 49 4e 44 45 58 | 28 67 29 29 3b 0a 0a 20 |AL INDEX|(g));.. |
|00001760| 20 20 57 69 74 68 20 41 | 4c 54 45 52 20 54 41 42 | With A|LTER TAB|
|00001770| 4c 45 3a 0a 0a 6d 79 73 | 71 6c 3e 20 41 4c 54 45 |LE:..mys|ql> ALTE|
|00001780| 52 20 54 41 42 4c 45 20 | 67 65 6f 6d 20 41 44 44 |R TABLE |geom ADD|
|00001790| 20 53 50 41 54 49 41 4c | 20 49 4e 44 45 58 28 67 | SPATIAL| INDEX(g|
|000017a0| 29 3b 0a 0a 20 20 20 57 | 69 74 68 20 43 52 45 41 |);.. W|ith CREA|
|000017b0| 54 45 20 49 4e 44 45 58 | 3a 0a 0a 6d 79 73 71 6c |TE INDEX|:..mysql|
|000017c0| 3e 20 43 52 45 41 54 45 | 20 53 50 41 54 49 41 4c |> CREATE| SPATIAL|
|000017d0| 20 49 4e 44 45 58 20 73 | 70 5f 69 6e 64 65 78 20 | INDEX s|p_index |
|000017e0| 4f 4e 20 67 65 6f 6d 20 | 28 67 29 3b 0a 0a 0a 54 |ON geom |(g);...T|
|000017f0| 6f 20 64 72 6f 70 20 73 | 70 61 74 69 61 6c 20 69 |o drop s|patial i|
|00001800| 6e 64 65 78 65 73 2c 20 | 75 73 65 20 41 4c 54 45 |ndexes, |use ALTE|
|00001810| 52 20 54 41 42 4c 45 20 | 6f 72 20 44 52 4f 50 20 |R TABLE |or DROP |
|00001820| 49 4e 44 45 58 3a 0a 0a | 0a 20 20 20 57 69 74 68 |INDEX:..|. With|
|00001830| 20 41 4c 54 45 52 20 54 | 41 42 4c 45 3a 0a 0a 6d | ALTER T|ABLE:..m|
|00001840| 79 73 71 6c 3e 20 41 4c | 54 45 52 20 54 41 42 4c |ysql> AL|TER TABL|
|00001850| 45 20 67 65 6f 6d 20 44 | 52 4f 50 20 49 4e 44 45 |E geom D|ROP INDE|
|00001860| 58 20 67 3b 0a 0a 20 20 | 20 57 69 74 68 20 44 52 |X g;.. | With DR|
|00001870| 4f 50 20 49 4e 44 45 58 | 3a 0a 0a 6d 79 73 71 6c |OP INDEX|:..mysql|
|00001880| 3e 20 44 52 4f 50 20 49 | 4e 44 45 58 20 73 70 5f |> DROP I|NDEX sp_|
|00001890| 69 6e 64 65 78 20 4f 4e | 20 67 65 6f 6d 3b 0a 0a |index ON| geom;..|
|000018a0| 0a 45 78 61 6d 70 6c 65 | 3a 20 53 75 70 70 6f 73 |.Example|: Suppos|
|000018b0| 65 20 74 68 61 74 20 61 | 20 74 61 62 6c 65 20 67 |e that a| table g|
|000018c0| 65 6f 6d 20 63 6f 6e 74 | 61 69 6e 73 20 6d 6f 72 |eom cont|ains mor|
|000018d0| 65 20 74 68 61 6e 20 33 | 32 2c 30 30 30 20 67 65 |e than 3|2,000 ge|
|000018e0| 6f 6d 65 74 72 69 65 73 | 2c 0a 77 68 69 63 68 20 |ometries|,.which |
|000018f0| 61 72 65 20 73 74 6f 72 | 65 64 20 69 6e 20 74 68 |are stor|ed in th|
|00001900| 65 20 63 6f 6c 75 6d 6e | 20 67 20 6f 66 20 74 79 |e column| g of ty|
|00001910| 70 65 20 47 45 4f 4d 45 | 54 52 59 2e 0a 54 68 65 |pe GEOME|TRY..The|
|00001920| 20 74 61 62 6c 65 20 61 | 6c 73 6f 20 68 61 73 20 | table a|lso has |
|00001930| 61 6e 20 41 55 54 4f 5f | 49 4e 43 52 45 4d 45 4e |an AUTO_|INCREMEN|
|00001940| 54 20 63 6f 6c 75 6d 6e | 20 66 69 64 20 66 6f 72 |T column| fid for|
|00001950| 20 73 74 6f 72 69 6e 67 | 0a 6f 62 6a 65 63 74 20 | storing|.object |
|00001960| 49 44 20 76 61 6c 75 65 | 73 2e 0a 00 03 04 5f 01 |ID value|s....._.|
|00001970| 22 0f 00 00 00 04 4b 49 | 4c 4c 1a 00 25 04 45 61 |".....KI|LL..%.Ea|
|00001980| 63 68 20 63 6f 6e 6e 65 | 63 74 69 6f 6e 20 74 6f |ch conne|ction to|
|00001990| 20 40 63 6f 6d 6d 61 6e | 64 7b 6d 79 73 71 6c 64 | @comman|d{mysqld|
|000019a0| 7d 20 72 75 6e 73 20 69 | 6e 20 61 20 73 65 70 61 |} runs i|n a sepa|
|000019b0| 72 61 74 65 20 74 68 72 | 65 61 64 2e 20 20 59 6f |rate thr|ead. Yo|
|000019c0| 75 20 63 61 6e 20 73 65 | 65 0a 77 68 69 63 68 20 |u can se|e.which |
|000019d0| 74 68 72 65 61 64 73 20 | 61 72 65 20 72 75 6e 6e |threads |are runn|
|000019e0| 69 6e 67 20 77 69 74 68 | 20 74 68 65 20 53 48 4f |ing with| the SHO|
|000019f0| 57 20 50 52 4f 43 45 53 | 53 4c 49 53 54 20 73 74 |W PROCES|SLIST st|
|00001a00| 61 74 65 6d 65 6e 74 20 | 61 6e 64 20 6b 69 6c 6c |atement |and kill|
|00001a10| 0a 61 20 74 68 72 65 61 | 64 20 77 69 74 68 20 74 |.a threa|d with t|
|00001a20| 68 65 20 4b 49 4c 4c 20 | 74 68 72 65 61 64 5f 69 |he KILL |thread_i|
|00001a30| 64 20 73 74 61 74 65 6d | 65 6e 74 2e 0a 0a 41 73 |d statem|ent...As|
|00001a40| 20 6f 66 20 4d 79 53 51 | 4c 20 35 2e 30 2e 30 2c | of MySQ|L 5.0.0,|
|00001a50| 20 4b 49 4c 4c 20 61 6c | 6c 6f 77 73 20 74 68 65 | KILL al|lows the|
|00001a60| 20 6f 70 74 69 6f 6e 61 | 6c 20 43 4f 4e 4e 45 43 | optiona|l CONNEC|
|00001a70| 54 49 4f 4e 20 6f 72 0a | 51 55 45 52 59 20 6d 6f |TION or.|QUERY mo|
|00001a80| 64 69 66 69 65 72 73 3a | 0a 0a 0a 20 2d 2d 2d 20 |difiers:|... --- |
|00001a90| 4b 49 4c 4c 20 43 4f 4e | 4e 45 43 54 49 4f 4e 20 |KILL CON|NECTION |
|00001aa0| 69 73 20 74 68 65 20 73 | 61 6d 65 20 61 73 20 4b |is the s|ame as K|
|00001ab0| 49 4c 4c 20 77 69 74 68 | 20 6e 6f 20 6d 6f 64 69 |ILL with| no modi|
|00001ac0| 66 69 65 72 3a 0a 49 74 | 20 74 65 72 6d 69 6e 61 |fier:.It| termina|
|00001ad0| 74 65 73 20 74 68 65 20 | 63 6f 6e 6e 65 63 74 69 |tes the |connecti|
|00001ae0| 6f 6e 20 61 73 73 6f 63 | 69 61 74 65 64 20 77 69 |on assoc|iated wi|
|00001af0| 74 68 20 74 68 65 20 67 | 69 76 65 6e 20 40 76 61 |th the g|iven @va|
|00001b00| 72 7b 74 68 72 65 61 64 | 5f 69 64 7d 2e 0a 0a 20 |r{thread|_id}... |
|00001b10| 2d 2d 2d 20 4b 49 4c 4c | 20 51 55 45 52 59 20 74 |--- KILL| QUERY t|
|00001b20| 65 72 6d 69 6e 61 74 65 | 73 20 74 68 65 20 73 74 |erminate|s the st|
|00001b30| 61 74 65 6d 65 6e 74 20 | 74 68 61 74 20 74 68 65 |atement |that the|
|00001b40| 20 63 6f 6e 6e 65 63 74 | 69 6f 6e 20 63 75 72 72 | connect|ion curr|
|00001b50| 65 6e 74 6c 79 0a 69 73 | 20 65 78 65 63 75 74 69 |ently.is| executi|
|00001b60| 6e 67 2c 20 62 75 74 20 | 6c 65 61 76 65 73 20 74 |ng, but |leaves t|
|00001b70| 68 65 20 63 6f 6e 6e 65 | 63 74 69 6f 6e 20 69 6e |he conne|ction in|
|00001b80| 74 61 63 74 2e 0a 0a 0a | 49 66 20 79 6f 75 20 68 |tact....|If you h|
|00001b90| 61 76 65 20 74 68 65 20 | 50 52 4f 43 45 53 53 20 |ave the |PROCESS |
|00001ba0| 70 72 69 76 69 6c 65 67 | 65 2c 20 79 6f 75 20 63 |privileg|e, you c|
|00001bb0| 61 6e 20 73 65 65 20 61 | 6c 6c 20 74 68 72 65 61 |an see a|ll threa|
|00001bc0| 64 73 2e 0a 49 66 20 79 | 6f 75 20 68 61 76 65 20 |ds..If y|ou have |
|00001bd0| 74 68 65 20 53 55 50 45 | 52 20 70 72 69 76 69 6c |the SUPE|R privil|
|00001be0| 65 67 65 2c 20 79 6f 75 | 20 63 61 6e 20 6b 69 6c |ege, you| can kil|
|00001bf0| 6c 20 61 6c 6c 20 74 68 | 72 65 61 64 73 20 61 6e |l all th|reads an|
|00001c00| 64 0a 73 74 61 74 65 6d | 65 6e 74 73 2e 20 20 4f |d.statem|ents. O|
|00001c10| 74 68 65 72 77 69 73 65 | 2c 20 79 6f 75 20 63 61 |therwise|, you ca|
|00001c20| 6e 20 73 65 65 20 61 6e | 64 20 6b 69 6c 6c 20 6f |n see an|d kill o|
|00001c30| 6e 6c 79 20 79 6f 75 72 | 20 6f 77 6e 20 74 68 72 |nly your| own thr|
|00001c40| 65 61 64 73 20 61 6e 64 | 0a 73 74 61 74 65 6d 65 |eads and|.stateme|
|00001c50| 6e 74 73 2e 0a 0a 59 6f | 75 20 63 61 6e 20 61 6c |nts...Yo|u can al|
|00001c60| 73 6f 20 75 73 65 20 74 | 68 65 20 40 63 6f 6d 6d |so use t|he @comm|
|00001c70| 61 6e 64 7b 6d 79 73 71 | 6c 61 64 6d 69 6e 20 70 |and{mysq|ladmin p|
|00001c80| 72 6f 63 65 73 73 6c 69 | 73 74 7d 20 61 6e 64 20 |rocessli|st} and |
|00001c90| 40 63 6f 6d 6d 61 6e 64 | 7b 6d 79 73 71 6c 61 64 |@command|{mysqlad|
|00001ca0| 6d 69 6e 20 6b 69 6c 6c | 7d 0a 63 6f 6d 6d 61 6e |min kill|}.comman|
|00001cb0| 64 73 20 74 6f 20 65 78 | 61 6d 69 6e 65 20 61 6e |ds to ex|amine an|
|00001cc0| 64 20 6b 69 6c 6c 20 74 | 68 72 65 61 64 73 2e 0a |d kill t|hreads..|
|00001cd0| 0a 4e 6f 74 65 3a 20 59 | 6f 75 20 63 75 72 72 65 |.Note: Y|ou curre|
|00001ce0| 6e 74 6c 79 20 63 61 6e | 6e 6f 74 20 75 73 65 20 |ntly can|not use |
|00001cf0| 4b 49 4c 4c 20 77 69 74 | 68 20 74 68 65 20 45 6d |KILL wit|h the Em|
|00001d00| 62 65 64 64 65 64 20 4d | 79 53 51 4c 0a 53 65 72 |bedded M|ySQL.Ser|
|00001d10| 76 65 72 20 6c 69 62 72 | 61 72 79 2c 20 62 65 63 |ver libr|ary, bec|
|00001d20| 61 75 73 65 20 74 68 65 | 20 65 6d 62 65 64 64 65 |ause the| embedde|
|00001d30| 64 20 73 65 72 76 65 72 | 20 6d 65 72 65 6c 79 20 |d server| merely |
|00001d40| 72 75 6e 73 20 69 6e 73 | 69 64 65 20 74 68 65 20 |runs ins|ide the |
|00001d50| 74 68 72 65 61 64 73 0a | 6f 66 20 74 68 65 20 68 |threads.|of the h|
|00001d60| 6f 73 74 20 61 70 70 6c | 69 63 61 74 69 6f 6e 2c |ost appl|ication,|
|00001d70| 20 69 74 20 64 6f 65 73 | 20 6e 6f 74 20 63 72 65 | it does| not cre|
|00001d80| 61 74 65 20 63 6f 6e 6e | 65 63 74 69 6f 6e 20 74 |ate conn|ection t|
|00001d90| 68 72 65 61 64 73 20 6f | 66 20 69 74 73 20 6f 77 |hreads o|f its ow|
|00001da0| 6e 2e 0a 29 00 4b 49 4c | 4c 20 5b 43 4f 4e 4e 45 |n..).KIL|L [CONNE|
|00001db0| 43 54 49 4f 4e 20 7c 20 | 51 55 45 52 59 5d 20 40 |CTION | |QUERY] @|
|00001dc0| 76 61 72 7b 74 68 72 65 | 61 64 5f 69 64 7d 00 00 |var{thre|ad_id}..|
|00001dd0| 03 00 93 01 22 10 00 00 | 00 0a 42 49 54 5f 4c 45 |...."...|..BIT_LE|
|00001de0| 4e 47 54 48 0b 00 4d 00 | 20 20 20 42 49 54 5f 4c |NGTH..M.| BIT_L|
|00001df0| 45 4e 47 54 48 28 40 76 | 61 72 7b 73 74 72 7d 29 |ENGTH(@v|ar{str})|
|00001e00| 0a 52 65 74 75 72 6e 73 | 20 74 68 65 20 6c 65 6e |.Returns| the len|
|00001e10| 67 74 68 20 6f 66 20 74 | 68 65 20 73 74 72 69 6e |gth of t|he strin|
|00001e20| 67 20 40 76 61 72 7b 73 | 74 72 7d 20 69 6e 20 62 |g @var{s|tr} in b|
|00001e30| 69 74 73 2e 0a 2f 00 6d | 79 73 71 6c 3e 20 53 45 |its../.m|ysql> SE|
|00001e40| 4c 45 43 54 20 42 49 54 | 5f 4c 45 4e 47 54 48 28 |LECT BIT|_LENGTH(|
|00001e50| 27 74 65 78 74 27 29 3b | 0a 20 20 20 20 20 20 20 |'text');|. |
|00001e60| 20 2d 3e 20 33 32 00 00 | 03 01 1e 02 22 11 00 00 | -> 32..|...."...|
|00001e70| 00 08 47 45 4f 4d 45 54 | 52 59 18 00 be 00 4d 79 |..GEOMET|RY....My|
|00001e80| 53 51 4c 20 70 72 6f 76 | 69 64 65 73 20 61 20 73 |SQL prov|ides a s|
|00001e90| 74 61 6e 64 61 72 64 20 | 77 61 79 20 6f 66 20 63 |tandard |way of c|
|00001ea0| 72 65 61 74 69 6e 67 20 | 73 70 61 74 69 61 6c 20 |reating |spatial |
|00001eb0| 63 6f 6c 75 6d 6e 73 20 | 66 6f 72 0a 67 65 6f 6d |columns |for.geom|
|00001ec0| 65 74 72 79 20 74 79 70 | 65 73 2c 20 66 6f 72 20 |etry typ|es, for |
|00001ed0| 65 78 61 6d 70 6c 65 2c | 20 77 69 74 68 20 43 52 |example,| with CR|
|00001ee0| 45 41 54 45 20 54 41 42 | 4c 45 20 6f 72 20 41 4c |EATE TAB|LE or AL|
|00001ef0| 54 45 52 20 54 41 42 4c | 45 2e 0a 43 75 72 72 65 |TER TABL|E..Curre|
|00001f00| 6e 74 6c 79 2c 20 73 70 | 61 74 69 61 6c 20 63 6f |ntly, sp|atial co|
|00001f10| 6c 75 6d 6e 73 20 61 72 | 65 20 73 75 70 70 6f 72 |lumns ar|e suppor|
|00001f20| 74 65 64 20 6f 6e 6c 79 | 20 66 6f 72 20 4d 79 49 |ted only| for MyI|
|00001f30| 53 41 4d 20 74 61 62 6c | 65 73 2e 0a 4b 00 6d 79 |SAM tabl|es..K.my|
|00001f40| 73 71 6c 3e 20 43 52 45 | 41 54 45 20 54 41 42 4c |sql> CRE|ATE TABL|
|00001f50| 45 20 67 65 6f 6d 20 28 | 67 20 47 45 4f 4d 45 54 |E geom (|g GEOMET|
|00001f60| 52 59 29 3b 0a 51 75 65 | 72 79 20 4f 4b 2c 20 30 |RY);.Que|ry OK, 0|
|00001f70| 20 72 6f 77 73 20 61 66 | 66 65 63 74 65 64 20 28 | rows af|fected (|
|00001f80| 30 2e 30 32 20 73 65 63 | 29 00 00 00 01 02 dd 22 |0.02 sec|)......"|
|00001f90| 12 00 00 00 0b 49 4e 53 | 45 52 54 20 49 4e 54 4f |.....INS|ERT INTO|
|00001fa0| 1a 00 eb 01 49 4e 53 45 | 52 54 20 69 6e 73 65 72 |....INSE|RT inser|
|00001fb0| 74 73 20 6e 65 77 20 72 | 6f 77 73 20 69 6e 74 6f |ts new r|ows into|
|00001fc0| 20 61 6e 20 65 78 69 73 | 74 69 6e 67 20 74 61 62 | an exis|ting tab|
|00001fd0| 6c 65 2e 20 20 54 68 65 | 20 49 4e 53 45 52 54 20 |le. The| INSERT |
|00001fe0| 2e 2e 2e 0a 56 41 4c 55 | 45 53 20 61 6e 64 20 49 |....VALU|ES and I|
|00001ff0| 4e 53 45 52 54 20 2e 2e | 2e 20 53 45 54 20 66 6f |NSERT ..|. SET fo|
|00002000| 72 6d 73 20 6f 66 20 74 | 68 65 20 73 74 61 74 65 |rms of t|he state|
|00002010| 6d 65 6e 74 20 69 6e 73 | 65 72 74 20 72 6f 77 73 |ment ins|ert rows|
|00002020| 20 62 61 73 65 64 0a 6f | 6e 20 65 78 70 6c 69 63 | based.o|n explic|
|00002030| 69 74 6c 79 20 73 70 65 | 63 69 66 69 65 64 20 76 |itly spe|cified v|
|00002040| 61 6c 75 65 73 2e 20 20 | 54 68 65 20 49 4e 53 45 |alues. |The INSE|
|00002050| 52 54 20 2e 2e 2e 20 53 | 45 4c 45 43 54 20 66 6f |RT ... S|ELECT fo|
|00002060| 72 6d 20 69 6e 73 65 72 | 74 73 0a 72 6f 77 73 20 |rm inser|ts.rows |
|00002070| 73 65 6c 65 63 74 65 64 | 20 66 72 6f 6d 20 61 6e |selected| from an|
|00002080| 6f 74 68 65 72 20 74 61 | 62 6c 65 20 6f 72 20 74 |other ta|ble or t|
|00002090| 61 62 6c 65 73 2e 20 20 | 54 68 65 20 49 4e 53 45 |ables. |The INSE|
|000020a0| 52 54 20 2e 2e 2e 20 56 | 41 4c 55 45 53 0a 66 6f |RT ... V|ALUES.fo|
|000020b0| 72 6d 20 77 69 74 68 20 | 6d 75 6c 74 69 70 6c 65 |rm with |multiple|
|000020c0| 20 76 61 6c 75 65 20 6c | 69 73 74 73 20 69 73 20 | value l|ists is |
|000020d0| 73 75 70 70 6f 72 74 65 | 64 20 69 6e 20 4d 79 53 |supporte|d in MyS|
|000020e0| 51 4c 20 33 2e 32 32 2e | 35 20 6f 72 0a 6c 61 74 |QL 3.22.|5 or.lat|
|000020f0| 65 72 2e 20 20 54 68 65 | 20 49 4e 53 45 52 54 20 |er. The| INSERT |
|00002100| 2e 2e 2e 20 53 45 54 20 | 73 79 6e 74 61 78 20 69 |... SET |syntax i|
|00002110| 73 20 73 75 70 70 6f 72 | 74 65 64 20 69 6e 20 4d |s suppor|ted in M|
|00002120| 79 53 51 4c 0a 33 2e 32 | 32 2e 31 30 20 6f 72 20 |ySQL.3.2|2.10 or |
|00002130| 6c 61 74 65 72 2e 0a 49 | 4e 53 45 52 54 20 2e 2e |later..I|NSERT ..|
|00002140| 2e 20 53 45 4c 45 43 54 | 20 69 73 20 64 69 73 63 |. SELECT| is disc|
|00002150| 75 73 73 65 64 20 66 75 | 72 74 68 65 72 20 69 6e |ussed fu|rther in|
|00002160| 0a 53 65 65 20 61 6c 73 | 6f 20 3a 20 5b 49 4e 53 |.See als|o : [INS|
|00002170| 45 52 54 20 53 45 4c 45 | 43 54 2c 20 20 2c 20 49 |ERT SELE|CT, , I|
|00002180| 4e 53 45 52 54 20 53 45 | 4c 45 43 54 5d 2e 0a da |NSERT SE|LECT]...|
|00002190| 00 49 4e 53 45 52 54 20 | 5b 4c 4f 57 5f 50 52 49 |.INSERT |[LOW_PRI|
|000021a0| 4f 52 49 54 59 20 7c 20 | 44 45 4c 41 59 45 44 20 |ORITY | |DELAYED |
|000021b0| 7c 20 48 49 47 48 5f 50 | 52 49 4f 52 49 54 59 5d || HIGH_P|RIORITY]|
|000021c0| 20 5b 49 47 4e 4f 52 45 | 5d 0a 20 20 20 20 5b 49 | [IGNORE|]. [I|
|000021d0| 4e 54 4f 5d 20 40 76 61 | 72 7b 74 62 6c 5f 6e 61 |NTO] @va|r{tbl_na|
|000021e0| 6d 65 7d 20 5b 28 40 76 | 61 72 7b 63 6f 6c 5f 6e |me} [(@v|ar{col_n|
|000021f0| 61 6d 65 7d 2c 2e 2e 2e | 29 5d 0a 20 20 20 20 56 |ame},...|)]. V|
|00002200| 41 4c 55 45 53 20 28 7b | 40 76 61 72 7b 65 78 70 |ALUES ({|@var{exp|
|00002210| 72 7d 20 7c 20 44 45 46 | 41 55 4c 54 7d 2c 2e 2e |r} | DEF|AULT},..|
|00002220| 2e 29 2c 28 2e 2e 2e 29 | 2c 2e 2e 2e 0a 20 20 20 |.),(...)|,.... |
|00002230| 20 5b 20 4f 4e 20 44 55 | 50 4c 49 43 41 54 45 20 | [ ON DU|PLICATE |
|00002240| 4b 45 59 20 55 50 44 41 | 54 45 20 40 76 61 72 7b |KEY UPDA|TE @var{|
|00002250| 63 6f 6c 5f 6e 61 6d 65 | 7d 3d 40 76 61 72 7b 65 |col_name|}=@var{e|
|00002260| 78 70 72 7d 2c 20 2e 2e | 2e 20 5d 00 01 00 b9 32 |xpr}, ..|. ]....2|
|00002270| 13 00 00 00 09 53 41 56 | 45 50 4f 49 4e 54 17 00 |.....SAV|EPOINT..|
|00002280| a5 00 53 41 56 45 50 4f | 49 4e 54 20 69 64 65 6e |..SAVEPO|INT iden|
|00002290| 74 69 66 69 65 72 0a 52 | 4f 4c 4c 42 41 43 4b 20 |tifier.R|OLLBACK |
|000022a0| 54 4f 20 53 41 56 45 50 | 4f 49 4e 54 20 69 64 65 |TO SAVEP|OINT ide|
|000022b0| 6e 74 69 66 69 65 72 0a | 0a 53 74 61 72 74 69 6e |ntifier.|.Startin|
|000022c0| 67 20 66 72 6f 6d 20 4d | 79 53 51 4c 20 34 2e 30 |g from M|ySQL 4.0|
|000022d0| 2e 31 34 20 61 6e 64 20 | 34 2e 31 2e 31 2c 20 49 |.14 and |4.1.1, I|
|000022e0| 6e 6e 6f 44 42 20 73 75 | 70 70 6f 72 74 73 20 74 |nnoDB su|pports t|
|000022f0| 68 65 20 53 51 4c 20 73 | 74 61 74 65 6d 65 6e 74 |he SQL s|tatement|
|00002300| 73 0a 53 41 56 45 50 4f | 49 4e 54 20 61 6e 64 20 |s.SAVEPO|INT and |
|00002310| 52 4f 4c 4c 42 41 43 4b | 20 54 4f 20 53 41 56 45 |ROLLBACK| TO SAVE|
|00002320| 50 4f 49 4e 54 2e 0a 00 | 01 00 65 2a 14 00 00 00 |POINT...|..e*....|
|00002330| 05 50 55 52 47 45 1a 00 | 55 00 50 55 52 47 45 20 |.PURGE..|U.PURGE |
|00002340| 4d 41 53 54 45 52 20 4c | 4f 47 53 20 54 4f 20 27 |MASTER L|OGS TO '|
|00002350| 6d 79 73 71 6c 2d 62 69 | 6e 2e 30 31 30 27 3b 0a |mysql-bi|n.010';.|
|00002360| 50 55 52 47 45 20 4d 41 | 53 54 45 52 20 4c 4f 47 |PURGE MA|STER LOG|
|00002370| 53 20 42 45 46 4f 52 45 | 20 27 32 30 30 33 2d 30 |S BEFORE| '2003-0|
|00002380| 34 2d 30 32 20 32 32 3a | 34 36 3a 32 36 27 3b 00 |4-02 22:|46:26';.|
|00002390| 01 01 6d 22 15 00 00 00 | 05 43 48 45 43 4b 13 00 |..m"....|.CHECK..|
|000023a0| da 00 43 48 45 43 4b 20 | 54 41 42 4c 45 20 77 6f |..CHECK |TABLE wo|
|000023b0| 72 6b 73 20 6f 6e 6c 79 | 20 6f 6e 20 4d 79 49 53 |rks only| on MyIS|
|000023c0| 41 4d 20 61 6e 64 20 49 | 6e 6e 6f 44 42 20 74 61 |AM and I|nnoDB ta|
|000023d0| 62 6c 65 73 2e 20 4f 6e | 0a 4d 79 49 53 41 4d 20 |bles. On|.MyISAM |
|000023e0| 74 61 62 6c 65 73 2c 20 | 54 68 69 73 20 69 73 20 |tables, |This is |
|000023f0| 74 68 65 20 73 61 6d 65 | 20 74 68 69 6e 67 20 61 |the same| thing a|
|00002400| 73 20 72 75 6e 6e 69 6e | 67 20 40 63 6f 6d 6d 61 |s runnin|g @comma|
|00002410| 6e 64 7b 6d 79 69 73 61 | 6d 63 68 6b 0a 2d 2d 6d |nd{myisa|mchk.--m|
|00002420| 65 64 69 75 6d 2d 63 68 | 65 63 6b 20 40 76 61 72 |edium-ch|eck @var|
|00002430| 7b 74 62 6c 5f 6e 61 6d | 65 7d 7d 20 6f 6e 20 74 |{tbl_nam|e}} on t|
|00002440| 68 65 20 74 61 62 6c 65 | 2e 0a 0a 49 66 20 79 6f |he table|...If yo|
|00002450| 75 20 64 6f 6e 27 74 20 | 73 70 65 63 69 66 79 20 |u don't |specify |
|00002460| 61 6e 79 20 6f 70 74 69 | 6f 6e 2c 20 4d 45 44 49 |any opti|on, MEDI|
|00002470| 55 4d 20 69 73 20 75 73 | 65 64 2e 0a 81 00 43 48 |UM is us|ed....CH|
|00002480| 45 43 4b 20 54 41 42 4c | 45 20 40 76 61 72 7b 74 |ECK TABL|E @var{t|
|00002490| 62 6c 5f 6e 61 6d 65 7d | 20 5b 2c 20 40 76 61 72 |bl_name}| [, @var|
|000024a0| 7b 74 62 6c 5f 6e 61 6d | 65 7d 5d 20 2e 2e 2e 20 |{tbl_nam|e}] ... |
|000024b0| 5b 40 76 61 72 7b 6f 70 | 74 69 6f 6e 7d 5d 20 2e |[@var{op|tion}] .|
|000024c0| 2e 2e 0a 0a 40 76 61 72 | 7b 6f 70 74 69 6f 6e 7d |....@var|{option}|
|000024d0| 20 3d 20 7b 51 55 49 43 | 4b 20 7c 20 46 41 53 54 | = {QUIC|K | FAST|
|000024e0| 20 7c 20 4d 45 44 49 55 | 4d 20 7c 20 45 58 54 45 | | MEDIU|M | EXTE|
|000024f0| 4e 44 45 44 20 7c 20 43 | 48 41 4e 47 45 44 7d 00 |NDED | C|HANGED}.|
|00002500| 03 00 eb 01 22 16 00 00 | 00 07 57 45 45 4b 44 41 |...."...|..WEEKDA|
|00002510| 59 0f 00 6b 00 20 20 20 | 57 45 45 4b 44 41 59 28 |Y..k. |WEEKDAY(|
|00002520| 40 76 61 72 7b 64 61 74 | 65 7d 29 0a 52 65 74 75 |@var{dat|e}).Retu|
|00002530| 72 6e 73 20 74 68 65 20 | 77 65 65 6b 64 61 79 20 |rns the |weekday |
|00002540| 69 6e 64 65 78 20 66 6f | 72 0a 40 76 61 72 7b 64 |index fo|r.@var{d|
|00002550| 61 74 65 7d 20 28 30 20 | 3d 20 4d 6f 6e 64 61 79 |ate} (0 |= Monday|
|00002560| 2c 20 31 20 3d 20 54 75 | 65 73 64 61 79 2c 20 2e |, 1 = Tu|esday, .|
|00002570| 2e 2e 20 36 20 3d 20 53 | 75 6e 64 61 79 29 2e 0a |.. 6 = S|unday)..|
|00002580| 6c 00 6d 79 73 71 6c 3e | 20 53 45 4c 45 43 54 20 |l.mysql>| SELECT |
|00002590| 57 45 45 4b 44 41 59 28 | 27 31 39 39 38 2d 30 32 |WEEKDAY(|'1998-02|
|000025a0| 2d 30 33 20 32 32 3a 32 | 33 3a 30 30 27 29 3b 0a |-03 22:2|3:00');.|
|000025b0| 20 20 20 20 20 20 20 20 | 2d 3e 20 31 0a 6d 79 73 | |-> 1.mys|
|000025c0| 71 6c 3e 20 53 45 4c 45 | 43 54 20 57 45 45 4b 44 |ql> SELE|CT WEEKD|
|000025d0| 41 59 28 27 31 39 39 37 | 2d 31 31 2d 30 35 27 29 |AY('1997|-11-05')|
|000025e0| 3b 0a 20 20 20 20 20 20 | 20 20 2d 3e 20 32 00 00 |;. | -> 2..|
|000025f0| 03 00 b6 02 32 17 00 00 | 00 08 4d 42 52 45 51 55 |....2...|..MBREQU|
|00002600| 41 4c 06 00 a3 00 20 20 | 20 4d 42 52 45 71 75 61 |AL.... | MBREqua|
|00002610| 6c 28 40 76 61 72 7b 67 | 31 7d 2c 40 76 61 72 7b |l(@var{g|1},@var{|
|00002620| 67 32 7d 29 0a 52 65 74 | 75 72 6e 73 20 31 20 6f |g2}).Ret|urns 1 o|
|00002630| 72 20 30 20 74 6f 20 69 | 6e 64 69 63 61 74 65 20 |r 0 to i|ndicate |
|00002640| 77 68 65 74 68 65 72 20 | 6f 72 20 6e 6f 74 20 74 |whether |or not t|
|00002650| 68 65 20 4d 69 6e 69 6d | 75 6d 20 42 6f 75 6e 64 |he Minim|um Bound|
|00002660| 69 6e 67 20 52 65 63 74 | 61 6e 67 6c 65 73 20 6f |ing Rect|angles o|
|00002670| 66 0a 74 68 65 20 74 77 | 6f 20 67 65 6f 6d 65 74 |f.the tw|o geomet|
|00002680| 72 69 65 73 20 40 76 61 | 72 7b 67 31 7d 20 61 6e |ries @va|r{g1} an|
|00002690| 64 20 40 76 61 72 7b 67 | 32 7d 20 61 72 65 20 74 |d @var{g|2} are t|
|000026a0| 68 65 20 73 61 6d 65 2e | 0a 00 00 00 01 02 11 22 |he same.|......."|
|000026b0| 18 00 00 00 06 42 49 4e | 41 52 59 0b 00 57 01 20 |.....BIN|ARY..W. |
|000026c0| 20 20 42 49 4e 41 52 59 | 0a 54 68 65 20 42 49 4e | BINARY|.The BIN|
|000026d0| 41 52 59 20 6f 70 65 72 | 61 74 6f 72 20 63 61 73 |ARY oper|ator cas|
|000026e0| 74 73 20 74 68 65 20 73 | 74 72 69 6e 67 20 66 6f |ts the s|tring fo|
|000026f0| 6c 6c 6f 77 69 6e 67 20 | 69 74 20 74 6f 20 61 20 |llowing |it to a |
|00002700| 62 69 6e 61 72 79 20 73 | 74 72 69 6e 67 2e 0a 54 |binary s|tring..T|
|00002710| 68 69 73 20 69 73 20 61 | 6e 20 65 61 73 79 20 77 |his is a|n easy w|
|00002720| 61 79 20 74 6f 20 66 6f | 72 63 65 20 61 20 63 6f |ay to fo|rce a co|
|00002730| 6c 75 6d 6e 20 63 6f 6d | 70 61 72 69 73 6f 6e 20 |lumn com|parison |
|00002740| 74 6f 20 62 65 20 64 6f | 6e 65 20 62 79 74 65 20 |to be do|ne byte |
|00002750| 62 79 20 62 79 74 65 0a | 72 61 74 68 65 72 20 74 |by byte.|rather t|
|00002760| 68 61 6e 20 63 68 61 72 | 61 63 74 65 72 20 62 79 |han char|acter by|
|00002770| 20 63 68 61 72 61 63 74 | 65 72 2e 20 54 68 69 73 | charact|er. This|
|00002780| 20 63 61 75 73 65 73 20 | 74 68 65 20 63 6f 6d 70 | causes |the comp|
|00002790| 61 72 69 73 6f 6e 20 74 | 6f 20 62 65 0a 63 61 73 |arison t|o be.cas|
|000027a0| 65 20 73 65 6e 73 69 74 | 69 76 65 20 65 76 65 6e |e sensit|ive even|
|000027b0| 0a 69 66 20 74 68 65 20 | 63 6f 6c 75 6d 6e 20 69 |.if the |column i|
|000027c0| 73 6e 27 74 20 64 65 66 | 69 6e 65 64 20 61 73 20 |sn't def|ined as |
|000027d0| 42 49 4e 41 52 59 20 6f | 72 20 42 4c 4f 42 2e 0a |BINARY o|r BLOB..|
|000027e0| 42 49 4e 41 52 59 20 61 | 6c 73 6f 20 63 61 75 73 |BINARY a|lso caus|
|000027f0| 65 73 20 74 72 61 69 6c | 69 6e 67 20 73 70 61 63 |es trail|ing spac|
|00002800| 65 73 20 74 6f 20 62 65 | 20 73 69 67 6e 69 66 69 |es to be| signifi|
|00002810| 63 61 6e 74 2e 0a a7 00 | 6d 79 73 71 6c 3e 20 53 |cant....|mysql> S|
|00002820| 45 4c 45 43 54 20 27 61 | 27 20 3d 20 27 41 27 3b |ELECT 'a|' = 'A';|
|00002830| 0a 20 20 20 20 20 20 20 | 20 2d 3e 20 31 0a 6d 79 |. | -> 1.my|
|00002840| 73 71 6c 3e 20 53 45 4c | 45 43 54 20 42 49 4e 41 |sql> SEL|ECT BINA|
|00002850| 52 59 20 27 61 27 20 3d | 20 27 41 27 3b 0a 20 20 |RY 'a' =| 'A';. |
|00002860| 20 20 20 20 20 20 2d 3e | 20 30 0a 6d 79 73 71 6c | ->| 0.mysql|
|00002870| 3e 20 53 45 4c 45 43 54 | 20 27 61 27 20 3d 20 27 |> SELECT| 'a' = '|
|00002880| 61 20 27 3b 0a 20 20 20 | 20 20 20 20 20 2d 3e 20 |a ';. | -> |
|00002890| 31 0a 6d 79 73 71 6c 3e | 20 53 45 4c 45 43 54 20 |1.mysql>| SELECT |
|000028a0| 42 49 4e 41 52 59 20 27 | 61 27 20 3d 20 27 61 20 |BINARY '|a' = 'a |
|000028b0| 27 3b 0a 20 20 20 20 20 | 20 20 20 2d 3e 20 30 00 |';. | -> 0.|
|000028c0| 03 00 f7 01 32 19 00 00 | 00 06 53 54 44 44 45 56 |....2...|..STDDEV|
|000028d0| 16 00 e6 00 20 20 20 53 | 54 44 28 40 76 61 72 7b |.... S|TD(@var{|
|000028e0| 65 78 70 72 7d 29 0a 20 | 20 20 53 54 44 44 45 56 |expr}). | STDDEV|
|000028f0| 28 40 76 61 72 7b 65 78 | 70 72 7d 29 0a 52 65 74 |(@var{ex|pr}).Ret|
|00002900| 75 72 6e 73 20 74 68 65 | 20 73 74 61 6e 64 61 72 |urns the| standar|
|00002910| 64 20 64 65 76 69 61 74 | 69 6f 6e 20 6f 66 20 40 |d deviat|ion of @|
|00002920| 76 61 72 7b 65 78 70 72 | 7d 20 28 74 68 65 20 73 |var{expr|} (the s|
|00002930| 71 75 61 72 65 20 72 6f | 6f 74 20 6f 66 0a 56 41 |quare ro|ot of.VA|
|00002940| 52 49 41 4e 43 45 28 29 | 29 2e 20 54 68 69 73 20 |RIANCE()|). This |
|00002950| 69 73 20 61 6e 20 65 78 | 74 65 6e 73 69 6f 6e 20 |is an ex|tension |
|00002960| 74 6f 20 73 74 61 6e 64 | 61 72 64 20 53 51 4c 2e |to stand|ard SQL.|
|00002970| 20 54 68 65 20 53 54 44 | 44 45 56 28 29 0a 66 6f | The STD|DEV().fo|
|00002980| 72 6d 20 6f 66 20 74 68 | 69 73 20 66 75 6e 63 74 |rm of th|is funct|
|00002990| 69 6f 6e 20 69 73 20 70 | 72 6f 76 69 64 65 64 20 |ion is p|rovided |
|000029a0| 66 6f 72 20 4f 72 61 63 | 6c 65 20 63 6f 6d 70 61 |for Orac|le compa|
|000029b0| 74 69 62 69 6c 69 74 79 | 2e 0a 00 00 03 00 8c 00 |tibility|........|
|000029c0| 22 1a 00 00 00 03 53 49 | 4e 0a 00 50 00 20 20 20 |".....SI|N..P. |
|000029d0| 53 49 4e 28 40 76 61 72 | 7b 58 7d 29 0a 52 65 74 |SIN(@var|{X}).Ret|
|000029e0| 75 72 6e 73 20 74 68 65 | 20 73 69 6e 65 20 6f 66 |urns the| sine of|
|000029f0| 20 40 76 61 72 7b 58 7d | 2c 20 77 68 65 72 65 20 | @var{X}|, where |
|00002a00| 40 76 61 72 7b 58 7d 20 | 69 73 20 67 69 76 65 6e |@var{X} |is given|
|00002a10| 20 69 6e 20 72 61 64 69 | 61 6e 73 2e 0a 2c 00 6d | in radi|ans..,.m|
|00002a20| 79 73 71 6c 3e 20 53 45 | 4c 45 43 54 20 53 49 4e |ysql> SE|LECT SIN|
|00002a30| 28 50 49 28 29 29 3b 0a | 20 20 20 20 20 20 20 20 |(PI());.| |
|00002a40| 2d 3e 20 30 2e 30 30 30 | 30 30 30 00 01 06 c5 32 |-> 0.000|000....2|
|00002a50| 1b 00 00 00 04 43 48 41 | 52 01 00 b6 06 20 20 20 |.....CHA|R.... |
|00002a60| 5b 4e 41 54 49 4f 4e 41 | 4c 5d 20 43 48 41 52 28 |[NATIONA|L] CHAR(|
|00002a70| 40 76 61 72 7b 4d 7d 29 | 20 5b 42 49 4e 41 52 59 |@var{M})| [BINARY|
|00002a80| 20 7c 20 41 53 43 49 49 | 20 7c 20 55 4e 49 43 4f | | ASCII| | UNICO|
|00002a90| 44 45 5d 0a 0a 41 20 66 | 69 78 65 64 2d 6c 65 6e |DE]..A f|ixed-len|
|00002aa0| 67 74 68 20 73 74 72 69 | 6e 67 20 74 68 61 74 20 |gth stri|ng that |
|00002ab0| 69 73 20 61 6c 77 61 79 | 73 20 72 69 67 68 74 2d |is alway|s right-|
|00002ac0| 70 61 64 64 65 64 20 77 | 69 74 68 20 73 70 61 63 |padded w|ith spac|
|00002ad0| 65 73 20 74 6f 20 74 68 | 65 0a 73 70 65 63 69 66 |es to th|e.specif|
|00002ae0| 69 65 64 20 6c 65 6e 67 | 74 68 20 77 68 65 6e 20 |ied leng|th when |
|00002af0| 73 74 6f 72 65 64 2e 20 | 20 40 76 61 72 7b 4d 7d |stored. | @var{M}|
|00002b00| 20 72 65 70 72 65 73 65 | 6e 74 73 20 74 68 65 20 | represe|nts the |
|00002b10| 63 6f 6c 75 6d 6e 20 6c | 65 6e 67 74 68 2e 20 20 |column l|ength. |
|00002b20| 54 68 65 0a 72 61 6e 67 | 65 20 6f 66 20 40 76 61 |The.rang|e of @va|
|00002b30| 72 7b 4d 7d 20 69 73 20 | 30 20 74 6f 20 32 35 35 |r{M} is |0 to 255|
|00002b40| 20 63 68 61 72 61 63 74 | 65 72 73 20 28 31 20 74 | charact|ers (1 t|
|00002b50| 6f 20 32 35 35 20 70 72 | 69 6f 72 20 74 6f 20 4d |o 255 pr|ior to M|
|00002b60| 79 53 51 4c 20 33 2e 32 | 33 29 2e 0a 0a 4e 6f 74 |ySQL 3.2|3)...Not|
|00002b70| 65 3a 20 54 72 61 69 6c | 69 6e 67 20 73 70 61 63 |e: Trail|ing spac|
|00002b80| 65 73 20 61 72 65 20 72 | 65 6d 6f 76 65 64 20 77 |es are r|emoved w|
|00002b90| 68 65 6e 20 43 48 41 52 | 20 76 61 6c 75 65 73 20 |hen CHAR| values |
|00002ba0| 61 72 65 0a 72 65 74 72 | 69 65 76 65 64 2e 0a 0a |are.retr|ieved...|
|00002bb0| 46 72 6f 6d 20 4d 79 53 | 51 4c 20 34 2e 31 2e 30 |From MyS|QL 4.1.0|
|00002bc0| 2c 20 61 20 43 48 41 52 | 20 63 6f 6c 75 6d 6e 20 |, a CHAR| column |
|00002bd0| 77 69 74 68 20 61 20 6c | 65 6e 67 74 68 20 73 70 |with a l|ength sp|
|00002be0| 65 63 69 66 69 63 61 74 | 69 6f 6e 20 67 72 65 61 |ecificat|ion grea|
|00002bf0| 74 65 72 0a 74 68 61 6e | 20 32 35 35 20 69 73 20 |ter.than| 255 is |
|00002c00| 63 6f 6e 76 65 72 74 65 | 64 20 74 6f 20 74 68 65 |converte|d to the|
|00002c10| 20 73 6d 61 6c 6c 65 73 | 74 20 54 45 58 54 20 74 | smalles|t TEXT t|
|00002c20| 79 70 65 20 74 68 61 74 | 20 63 61 6e 20 68 6f 6c |ype that| can hol|
|00002c30| 64 20 76 61 6c 75 65 73 | 0a 6f 66 20 74 68 65 20 |d values|.of the |
|00002c40| 67 69 76 65 6e 20 6c 65 | 6e 67 74 68 2e 20 20 46 |given le|ngth. F|
|00002c50| 6f 72 20 65 78 61 6d 70 | 6c 65 2c 20 43 48 41 52 |or examp|le, CHAR|
|00002c60| 28 35 30 30 29 20 69 73 | 20 63 6f 6e 76 65 72 74 |(500) is| convert|
|00002c70| 65 64 20 74 6f 0a 54 45 | 58 54 2c 20 61 6e 64 20 |ed to.TE|XT, and |
|00002c80| 43 48 41 52 28 32 30 30 | 30 30 30 29 20 69 73 20 |CHAR(200|000) is |
|00002c90| 63 6f 6e 76 65 72 74 65 | 64 20 74 6f 20 4d 45 44 |converte|d to MED|
|00002ca0| 49 55 4d 54 45 58 54 2e | 0a 54 68 69 73 20 69 73 |IUMTEXT.|.This is|
|00002cb0| 20 61 20 63 6f 6d 70 61 | 74 69 62 69 6c 69 74 79 | a compa|tibility|
|00002cc0| 20 66 65 61 74 75 72 65 | 2e 20 20 48 6f 77 65 76 | feature|. Howev|
|00002cd0| 65 72 2c 20 74 68 69 73 | 20 63 6f 6e 76 65 72 73 |er, this| convers|
|00002ce0| 69 6f 6e 20 63 61 75 73 | 65 73 20 74 68 65 0a 63 |ion caus|es the.c|
|00002cf0| 6f 6c 75 6d 6e 20 74 6f | 20 62 65 63 6f 6d 65 20 |olumn to| become |
|00002d00| 61 20 76 61 72 69 61 62 | 6c 65 2d 6c 65 6e 67 74 |a variab|le-lengt|
|00002d10| 68 20 63 6f 6c 75 6d 6e | 2c 20 61 6e 64 20 61 6c |h column|, and al|
|00002d20| 73 6f 20 61 66 66 65 63 | 74 73 20 74 72 61 69 6c |so affec|ts trail|
|00002d30| 69 6e 67 2d 73 70 61 63 | 65 0a 72 65 6d 6f 76 61 |ing-spac|e.remova|
|00002d40| 6c 2e 0a 0a 43 48 41 52 | 20 69 73 20 73 68 6f 72 |l...CHAR| is shor|
|00002d50| 74 68 61 6e 64 20 66 6f | 72 20 43 48 41 52 41 43 |thand fo|r CHARAC|
|00002d60| 54 45 52 2e 0a 4e 41 54 | 49 4f 4e 41 4c 20 43 48 |TER..NAT|IONAL CH|
|00002d70| 41 52 20 28 6f 72 20 69 | 74 73 20 65 71 75 69 76 |AR (or i|ts equiv|
|00002d80| 61 6c 65 6e 74 20 73 68 | 6f 72 74 20 66 6f 72 6d |alent sh|ort form|
|00002d90| 2c 20 4e 43 48 41 52 29 | 20 69 73 20 74 68 65 0a |, NCHAR)| is the.|
|00002da0| 73 74 61 6e 64 61 72 64 | 20 53 51 4c 20 77 61 79 |standard| SQL way|
|00002db0| 20 74 6f 20 64 65 66 69 | 6e 65 20 74 68 61 74 20 | to defi|ne that |
|00002dc0| 61 20 43 48 41 52 20 63 | 6f 6c 75 6d 6e 20 73 68 |a CHAR c|olumn sh|
|00002dd0| 6f 75 6c 64 20 75 73 65 | 20 74 68 65 20 64 65 66 |ould use| the def|
|00002de0| 61 75 6c 74 0a 63 68 61 | 72 61 63 74 65 72 20 73 |ault.cha|racter s|
|00002df0| 65 74 2e 20 20 54 68 69 | 73 20 69 73 20 74 68 65 |et. Thi|s is the|
|00002e00| 20 64 65 66 61 75 6c 74 | 20 69 6e 20 4d 79 53 51 | default| in MySQ|
|00002e10| 4c 2e 0a 0a 54 68 65 20 | 42 49 4e 41 52 59 20 61 |L...The |BINARY a|
|00002e20| 74 74 72 69 62 75 74 65 | 20 63 61 75 73 65 73 20 |ttribute| causes |
|00002e30| 73 6f 72 74 69 6e 67 20 | 61 6e 64 20 63 6f 6d 70 |sorting |and comp|
|00002e40| 61 72 69 73 6f 6e 73 20 | 74 6f 20 62 65 0a 63 61 |arisons |to be.ca|
|00002e50| 73 65 20 73 65 6e 73 69 | 74 69 76 65 2e 0a 0a 46 |se sensi|tive...F|
|00002e60| 72 6f 6d 20 4d 79 53 51 | 4c 20 34 2e 31 2e 30 20 |rom MySQ|L 4.1.0 |
|00002e70| 6f 6e 2c 20 74 68 65 20 | 41 53 43 49 49 20 61 74 |on, the |ASCII at|
|00002e80| 74 72 69 62 75 74 65 20 | 63 61 6e 20 62 65 20 73 |tribute |can be s|
|00002e90| 70 65 63 69 66 69 65 64 | 2e 20 49 74 0a 61 73 73 |pecified|. It.ass|
|00002ea0| 69 67 6e 73 20 74 68 65 | 20 6c 61 74 69 6e 31 20 |igns the| latin1 |
|00002eb0| 63 68 61 72 61 63 74 65 | 72 20 73 65 74 20 74 6f |characte|r set to|
|00002ec0| 20 61 20 43 48 41 52 20 | 63 6f 6c 75 6d 6e 2e 0a | a CHAR |column..|
|00002ed0| 0a 46 72 6f 6d 20 4d 79 | 53 51 4c 20 34 2e 31 2e |.From My|SQL 4.1.|
|00002ee0| 31 20 6f 6e 2c 20 74 68 | 65 20 55 4e 49 43 4f 44 |1 on, th|e UNICOD|
|00002ef0| 45 20 61 74 74 72 69 62 | 75 74 65 20 63 61 6e 20 |E attrib|ute can |
|00002f00| 62 65 20 73 70 65 63 69 | 66 69 65 64 2e 20 49 74 |be speci|fied. It|
|00002f10| 0a 61 73 73 69 67 6e 73 | 20 74 68 65 20 75 63 73 |.assigns| the ucs|
|00002f20| 32 20 63 68 61 72 61 63 | 74 65 72 20 73 65 74 20 |2 charac|ter set |
|00002f30| 74 6f 20 61 20 43 48 41 | 52 20 63 6f 6c 75 6d 6e |to a CHA|R column|
|00002f40| 2e 0a 0a 4d 79 53 51 4c | 20 61 6c 6c 6f 77 73 20 |...MySQL| allows |
|00002f50| 79 6f 75 20 74 6f 20 63 | 72 65 61 74 65 20 61 20 |you to c|reate a |
|00002f60| 63 6f 6c 75 6d 6e 20 6f | 66 20 74 79 70 65 20 43 |column o|f type C|
|00002f70| 48 41 52 28 30 29 2e 20 | 54 68 69 73 20 69 73 20 |HAR(0). |This is |
|00002f80| 6d 61 69 6e 6c 79 0a 75 | 73 65 66 75 6c 20 77 68 |mainly.u|seful wh|
|00002f90| 65 6e 20 79 6f 75 20 68 | 61 76 65 20 74 6f 20 62 |en you h|ave to b|
|00002fa0| 65 20 63 6f 6d 70 6c 69 | 61 6e 74 20 77 69 74 68 |e compli|ant with|
|00002fb0| 20 73 6f 6d 65 20 6f 6c | 64 20 61 70 70 6c 69 63 | some ol|d applic|
|00002fc0| 61 74 69 6f 6e 73 20 74 | 68 61 74 20 64 65 70 65 |ations t|hat depe|
|00002fd0| 6e 64 0a 6f 6e 20 74 68 | 65 20 65 78 69 73 74 65 |nd.on th|e existe|
|00002fe0| 6e 63 65 20 6f 66 20 61 | 20 63 6f 6c 75 6d 6e 20 |nce of a| column |
|00002ff0| 62 75 74 20 74 68 61 74 | 20 64 6f 20 6e 6f 74 20 |but that| do not |
|00003000| 61 63 74 75 61 6c 6c 79 | 20 75 73 65 20 74 68 65 |actually| use the|
|00003010| 20 76 61 6c 75 65 2e 20 | 20 54 68 69 73 0a 69 73 | value. | This.is|
|00003020| 20 61 6c 73 6f 20 71 75 | 69 74 65 20 6e 69 63 65 | also qu|ite nice|
|00003030| 20 77 68 65 6e 20 79 6f | 75 20 6e 65 65 64 20 61 | when yo|u need a|
|00003040| 20 63 6f 6c 75 6d 6e 20 | 74 68 61 74 20 63 61 6e | column |that can|
|00003050| 20 74 61 6b 65 20 6f 6e | 6c 79 20 74 77 6f 20 76 | take on|ly two v|
|00003060| 61 6c 75 65 73 3a 20 41 | 0a 43 48 41 52 28 30 29 |alues: A|.CHAR(0)|
|00003070| 20 63 6f 6c 75 6d 6e 20 | 74 68 61 74 20 69 73 20 | column |that is |
|00003080| 6e 6f 74 20 64 65 66 69 | 6e 65 64 20 61 73 20 4e |not defi|ned as N|
|00003090| 4f 54 20 4e 55 4c 4c 20 | 6f 63 63 75 70 69 65 73 |OT NULL |occupies|
|000030a0| 20 6f 6e 6c 79 0a 6f 6e | 65 20 62 69 74 20 61 6e | only.on|e bit an|
|000030b0| 64 20 63 61 6e 20 74 61 | 6b 65 20 6f 6e 6c 79 20 |d can ta|ke only |
|000030c0| 74 68 65 20 76 61 6c 75 | 65 73 20 4e 55 4c 4c 20 |the valu|es NULL |
|000030d0| 61 6e 64 20 27 27 20 28 | 74 68 65 20 65 6d 70 74 |and '' (|the empt|
|000030e0| 79 0a 73 74 72 69 6e 67 | 29 2e 0a 0a 20 20 20 43 |y.string|)... C|
|000030f0| 48 41 52 0a 54 68 69 73 | 20 69 73 20 61 20 73 79 |HAR.This| is a sy|
|00003100| 6e 6f 6e 79 6d 20 66 6f | 72 20 43 48 41 52 28 31 |nonym fo|r CHAR(1|
|00003110| 29 2e 0a 00 01 00 a9 22 | 1c 00 00 00 04 53 51 52 |)......"|.....SQR|
|00003120| 54 0a 00 42 00 20 20 20 | 53 51 52 54 28 40 76 61 |T..B. |SQRT(@va|
|00003130| 72 7b 58 7d 29 0a 52 65 | 74 75 72 6e 73 20 74 68 |r{X}).Re|turns th|
|00003140| 65 20 6e 6f 6e 2d 6e 65 | 67 61 74 69 76 65 20 73 |e non-ne|gative s|
|00003150| 71 75 61 72 65 20 72 6f | 6f 74 20 6f 66 20 40 76 |quare ro|ot of @v|
|00003160| 61 72 7b 58 7d 2e 0a 56 | 00 6d 79 73 71 6c 3e 20 |ar{X}..V|.mysql> |
|00003170| 53 45 4c 45 43 54 20 53 | 51 52 54 28 34 29 3b 0a |SELECT S|QRT(4);.|
|00003180| 20 20 20 20 20 20 20 20 | 2d 3e 20 32 2e 30 30 30 | |-> 2.000|
|00003190| 30 30 30 0a 6d 79 73 71 | 6c 3e 20 53 45 4c 45 43 |000.mysq|l> SELEC|
|000031a0| 54 20 53 51 52 54 28 32 | 30 29 3b 0a 20 20 20 20 |T SQRT(2|0);. |
|000031b0| 20 20 20 20 2d 3e 20 34 | 2e 34 37 32 31 33 36 00 | -> 4|.472136.|
|000031c0| 03 02 07 01 22 1d 00 00 | 00 05 52 4f 55 4e 44 0a |...."...|..ROUND.|
|000031d0| 00 f1 00 20 20 20 52 4f | 55 4e 44 28 40 76 61 72 |... RO|UND(@var|
|000031e0| 7b 58 7d 29 0a 20 20 20 | 52 4f 55 4e 44 28 40 76 |{X}). |ROUND(@v|
|000031f0| 61 72 7b 58 7d 2c 40 76 | 61 72 7b 44 7d 29 0a 52 |ar{X},@v|ar{D}).R|
|00003200| 65 74 75 72 6e 73 20 74 | 68 65 20 61 72 67 75 6d |eturns t|he argum|
|00003210| 65 6e 74 20 40 76 61 72 | 7b 58 7d 2c 20 72 6f 75 |ent @var|{X}, rou|
|00003220| 6e 64 65 64 20 74 6f 20 | 74 68 65 20 6e 65 61 72 |nded to |the near|
|00003230| 65 73 74 20 69 6e 74 65 | 67 65 72 2e 0a 57 69 74 |est inte|ger..Wit|
|00003240| 68 20 74 77 6f 20 61 72 | 67 75 6d 65 6e 74 73 2c |h two ar|guments,|
|00003250| 20 72 65 74 75 72 6e 73 | 20 40 76 61 72 7b 58 7d | returns| @var{X}|
|00003260| 20 72 6f 75 6e 64 65 64 | 20 74 6f 20 40 76 61 72 | rounded| to @var|
|00003270| 7b 44 7d 20 64 65 63 69 | 6d 61 6c 73 2e 0a 49 66 |{D} deci|mals..If|
|00003280| 20 40 76 61 72 7b 44 7d | 20 69 73 20 6e 65 67 61 | @var{D}| is nega|
|00003290| 74 69 76 65 2c 20 74 68 | 65 20 69 6e 74 65 67 65 |tive, th|e intege|
|000032a0| 72 20 70 61 72 74 20 6f | 66 20 74 68 65 20 6e 75 |r part o|f the nu|
|000032b0| 6d 62 65 72 20 69 73 20 | 7a 65 72 6f 65 64 20 6f |mber is |zeroed o|
|000032c0| 75 74 2e 0a 04 01 6d 79 | 73 71 6c 3e 20 53 45 4c |ut....my|sql> SEL|
|000032d0| 45 43 54 20 52 4f 55 4e | 44 28 2d 31 2e 32 33 29 |ECT ROUN|D(-1.23)|
|000032e0| 3b 0a 20 20 20 20 20 20 | 20 20 2d 3e 20 2d 31 0a |;. | -> -1.|
|000032f0| 6d 79 73 71 6c 3e 20 53 | 45 4c 45 43 54 20 52 4f |mysql> S|ELECT RO|
|00003300| 55 4e 44 28 2d 31 2e 35 | 38 29 3b 0a 20 20 20 20 |UND(-1.5|8);. |
|00003310| 20 20 20 20 2d 3e 20 2d | 32 0a 6d 79 73 71 6c 3e | -> -|2.mysql>|
|00003320| 20 53 45 4c 45 43 54 20 | 52 4f 55 4e 44 28 31 2e | SELECT |ROUND(1.|
|00003330| 35 38 29 3b 0a 20 20 20 | 20 20 20 20 20 2d 3e 20 |58);. | -> |
|00003340| 32 0a 6d 79 73 71 6c 3e | 20 53 45 4c 45 43 54 20 |2.mysql>| SELECT |
|00003350| 52 4f 55 4e 44 28 31 2e | 32 39 38 2c 20 31 29 3b |ROUND(1.|298, 1);|
|00003360| 0a 20 20 20 20 20 20 20 | 20 2d 3e 20 31 2e 33 0a |. | -> 1.3.|
|00003370| 6d 79 73 71 6c 3e 20 53 | 45 4c 45 43 54 20 52 4f |mysql> S|ELECT RO|
|00003380| 55 4e 44 28 31 2e 32 39 | 38 2c 20 30 29 3b 0a 20 |UND(1.29|8, 0);. |
|00003390| 20 20 20 20 20 20 20 2d | 3e 20 31 0a 6d 79 73 71 | -|> 1.mysq|
|000033a0| 6c 3e 20 53 45 4c 45 43 | 54 20 52 4f 55 4e 44 28 |l> SELEC|T ROUND(|
|000033b0| 32 33 2e 32 39 38 2c 20 | 2d 31 29 3b 0a 20 20 20 |23.298, |-1);. |
|000033c0| 20 20 20 20 20 2d 3e 20 | 32 30 00 00 03 01 a0 00 | -> |20......|
|000033d0| 22 1e 00 00 00 06 43 4f | 4e 43 41 54 0b 00 ee 00 |".....CO|NCAT....|
|000033e0| 20 20 20 43 4f 4e 43 41 | 54 28 40 76 61 72 7b 73 | CONCA|T(@var{s|
|000033f0| 74 72 31 7d 2c 40 76 61 | 72 7b 73 74 72 32 7d 2c |tr1},@va|r{str2},|
|00003400| 2e 2e 2e 29 0a 52 65 74 | 75 72 6e 73 20 74 68 65 |...).Ret|urns the|
|00003410| 20 73 74 72 69 6e 67 20 | 74 68 61 74 20 72 65 73 | string |that res|
|00003420| 75 6c 74 73 20 66 72 6f | 6d 20 63 6f 6e 63 61 74 |ults fro|m concat|
|00003430| 65 6e 61 74 69 6e 67 20 | 74 68 65 20 61 72 67 75 |enating |the argu|
|00003440| 6d 65 6e 74 73 2e 20 20 | 52 65 74 75 72 6e 73 0a |ments. |Returns.|
|00003450| 4e 55 4c 4c 20 69 66 20 | 61 6e 79 20 61 72 67 75 |NULL if |any argu|
|00003460| 6d 65 6e 74 20 69 73 20 | 4e 55 4c 4c 2e 20 20 4d |ment is |NULL. M|
|00003470| 61 79 20 68 61 76 65 20 | 6f 6e 65 20 6f 72 20 6d |ay have |one or m|
|00003480| 6f 72 65 20 61 72 67 75 | 6d 65 6e 74 73 2e 0a 41 |ore argu|ments..A|
|00003490| 20 6e 75 6d 65 72 69 63 | 20 61 72 67 75 6d 65 6e | numeric| argumen|
|000034a0| 74 20 69 73 20 63 6f 6e | 76 65 72 74 65 64 20 74 |t is con|verted t|
|000034b0| 6f 20 69 74 73 20 65 71 | 75 69 76 61 6c 65 6e 74 |o its eq|uivalent|
|000034c0| 20 73 74 72 69 6e 67 20 | 66 6f 72 6d 2e 0a 9f 00 | string |form....|
|000034d0| 6d 79 73 71 6c 3e 20 53 | 45 4c 45 43 54 20 43 4f |mysql> S|ELECT CO|
|000034e0| 4e 43 41 54 28 27 4d 79 | 27 2c 20 27 53 27 2c 20 |NCAT('My|', 'S', |
|000034f0| 27 51 4c 27 29 3b 0a 20 | 20 20 20 20 20 20 20 2d |'QL');. | -|
|00003500| 3e 20 27 4d 79 53 51 4c | 27 0a 6d 79 73 71 6c 3e |> 'MySQL|'.mysql>|
|00003510| 20 53 45 4c 45 43 54 20 | 43 4f 4e 43 41 54 28 27 | SELECT |CONCAT('|
|00003520| 4d 79 27 2c 20 4e 55 4c | 4c 2c 20 27 51 4c 27 29 |My', NUL|L, 'QL')|
|00003530| 3b 0a 20 20 20 20 20 20 | 20 20 2d 3e 20 4e 55 4c |;. | -> NUL|
|00003540| 4c 0a 6d 79 73 71 6c 3e | 20 53 45 4c 45 43 54 20 |L.mysql>| SELECT |
|00003550| 43 4f 4e 43 41 54 28 31 | 34 2e 33 29 3b 0a 20 20 |CONCAT(1|4.3);. |
|00003560| 20 20 20 20 20 20 2d 3e | 20 27 31 34 2e 33 27 00 | ->| '14.3'.|
|00003570| 03 00 8b 01 32 1f 00 00 | 00 11 43 55 52 52 45 4e |....2...|..CURREN|
|00003580| 54 5f 54 49 4d 45 53 54 | 41 4d 50 0f 00 6f 00 20 |T_TIMEST|AMP..o. |
|00003590| 20 20 43 55 52 52 45 4e | 54 5f 54 49 4d 45 53 54 | CURREN|T_TIMEST|
|000035a0| 41 4d 50 0a 20 20 20 43 | 55 52 52 45 4e 54 5f 54 |AMP. C|URRENT_T|
|000035b0| 49 4d 45 53 54 41 4d 50 | 28 29 0a 0a 43 55 52 52 |IMESTAMP|()..CURR|
|000035c0| 45 4e 54 5f 54 49 4d 45 | 53 54 41 4d 50 20 61 6e |ENT_TIME|STAMP an|
|000035d0| 64 20 43 55 52 52 45 4e | 54 5f 54 49 4d 45 53 54 |d CURREN|T_TIMEST|
|000035e0| 41 4d 50 28 29 20 61 72 | 65 20 73 79 6e 6f 6e 79 |AMP() ar|e synony|
|000035f0| 6d 73 20 66 6f 72 0a 4e | 4f 57 28 29 2e 0a 00 00 |ms for.N|OW()....|
|00003600| 01 01 39 22 20 00 00 00 | 01 21 1b 00 79 00 20 20 |..9" ...|.!..y. |
|00003610| 20 4e 4f 54 0a 20 20 20 | 21 0a 4c 6f 67 69 63 61 | NOT. |!.Logica|
|00003620| 6c 20 4e 4f 54 2e 0a 45 | 76 61 6c 75 61 74 65 73 |l NOT..E|valuates|
|00003630| 20 74 6f 20 31 20 69 66 | 20 74 68 65 20 6f 70 65 | to 1 if| the ope|
|00003640| 72 61 6e 64 20 69 73 20 | 30 2c 0a 74 6f 20 30 20 |rand is |0,.to 0 |
|00003650| 69 66 20 74 68 65 20 6f | 70 65 72 61 6e 64 20 69 |if the o|perand i|
|00003660| 73 20 6e 6f 6e 2d 7a 65 | 72 6f 2c 0a 61 6e 64 20 |s non-ze|ro,.and |
|00003670| 4e 4f 54 20 4e 55 4c 4c | 20 72 65 74 75 72 6e 73 |NOT NULL| returns|
|00003680| 20 4e 55 4c 4c 2e 0a b2 | 00 6d 79 73 71 6c 3e 20 | NULL...|.mysql> |
|00003690| 53 45 4c 45 43 54 20 4e | 4f 54 20 31 30 3b 0a 20 |SELECT N|OT 10;. |
|000036a0| 20 20 20 20 20 20 20 2d | 3e 20 30 0a 6d 79 73 71 | -|> 0.mysq|
|000036b0| 6c 3e 20 53 45 4c 45 43 | 54 20 4e 4f 54 20 30 3b |l> SELEC|T NOT 0;|
|000036c0| 0a 20 20 20 20 20 20 20 | 20 2d 3e 20 31 0a 6d 79 |. | -> 1.my|
|000036d0| 73 71 6c 3e 20 53 45 4c | 45 43 54 20 4e 4f 54 20 |sql> SEL|ECT NOT |
|000036e0| 4e 55 4c 4c 3b 0a 20 20 | 20 20 20 20 20 20 2d 3e |NULL;. | ->|
|000036f0| 20 4e 55 4c 4c 0a 6d 79 | 73 71 6c 3e 20 53 45 4c | NULL.my|sql> SEL|
|00003700| 45 43 54 20 21 20 28 31 | 2b 31 29 3b 0a 20 20 20 |ECT ! (1|+1);. |
|00003710| 20 20 20 20 20 2d 3e 20 | 30 0a 6d 79 73 71 6c 3e | -> |0.mysql>|
|00003720| 20 53 45 4c 45 43 54 20 | 21 20 31 2b 31 3b 0a 20 | SELECT |! 1+1;. |
|00003730| 20 20 20 20 20 20 20 2d | 3e 20 31 00 01 01 65 22 | -|> 1...e"|
|00003740| 21 00 00 00 08 47 52 45 | 41 54 45 53 54 04 00 b6 |!....GRE|ATEST...|
|00003750| 00 20 20 20 47 52 45 41 | 54 45 53 54 28 40 76 61 |. GREA|TEST(@va|
|00003760| 72 7b 76 61 6c 75 65 31 | 7d 2c 40 76 61 72 7b 76 |r{value1|},@var{v|
|00003770| 61 6c 75 65 32 7d 2c 2e | 2e 2e 29 0a 57 69 74 68 |alue2},.|..).With|
|00003780| 20 74 77 6f 20 6f 72 20 | 6d 6f 72 65 20 61 72 67 | two or |more arg|
|00003790| 75 6d 65 6e 74 73 2c 20 | 72 65 74 75 72 6e 73 20 |uments, |returns |
|000037a0| 74 68 65 20 6c 61 72 67 | 65 73 74 20 28 6d 61 78 |the larg|est (max|
|000037b0| 69 6d 75 6d 2d 76 61 6c | 75 65 64 29 20 61 72 67 |imum-val|ued) arg|
|000037c0| 75 6d 65 6e 74 2e 0a 54 | 68 65 20 61 72 67 75 6d |ument..T|he argum|
|000037d0| 65 6e 74 73 20 61 72 65 | 20 63 6f 6d 70 61 72 65 |ents are| compare|
|000037e0| 64 20 75 73 69 6e 67 20 | 74 68 65 20 73 61 6d 65 |d using |the same|
|000037f0| 20 72 75 6c 65 73 20 61 | 73 20 66 6f 72 20 4c 45 | rules a|s for LE|
|00003800| 41 53 54 28 29 2e 0a 9a | 00 6d 79 73 71 6c 3e 20 |AST()...|.mysql> |
|00003810| 53 45 4c 45 43 54 20 47 | 52 45 41 54 45 53 54 28 |SELECT G|REATEST(|
|00003820| 32 2c 30 29 3b 0a 20 20 | 20 20 20 20 20 20 2d 3e |2,0);. | ->|
|00003830| 20 32 0a 6d 79 73 71 6c | 3e 20 53 45 4c 45 43 54 | 2.mysql|> SELECT|
|00003840| 20 47 52 45 41 54 45 53 | 54 28 33 34 2e 30 2c 33 | GREATES|T(34.0,3|
|00003850| 2e 30 2c 35 2e 30 2c 37 | 36 37 2e 30 29 3b 0a 20 |.0,5.0,7|67.0);. |
|00003860| 20 20 20 20 20 20 20 2d | 3e 20 37 36 37 2e 30 0a | -|> 767.0.|
|00003870| 6d 79 73 71 6c 3e 20 53 | 45 4c 45 43 54 20 47 52 |mysql> S|ELECT GR|
|00003880| 45 41 54 45 53 54 28 27 | 42 27 2c 27 41 27 2c 27 |EATEST('|B','A','|
|00003890| 43 27 29 3b 0a 20 20 20 | 20 20 20 20 20 2d 3e 20 |C');. | -> |
|000038a0| 27 43 27 00 03 00 ff 01 | 22 22 00 00 00 05 4c 4f |'C'.....|""....LO|
|000038b0| 57 45 52 0b 00 ad 00 20 | 20 20 4c 4f 57 45 52 28 |WER.... | LOWER(|
|000038c0| 40 76 61 72 7b 73 74 72 | 7d 29 0a 52 65 74 75 72 |@var{str|}).Retur|
|000038d0| 6e 73 20 74 68 65 20 73 | 74 72 69 6e 67 20 40 76 |ns the s|tring @v|
|000038e0| 61 72 7b 73 74 72 7d 20 | 77 69 74 68 20 61 6c 6c |ar{str} |with all|
|000038f0| 20 63 68 61 72 61 63 74 | 65 72 73 20 63 68 61 6e | charact|ers chan|
|00003900| 67 65 64 20 74 6f 20 6c | 6f 77 65 72 63 61 73 65 |ged to l|owercase|
|00003910| 0a 61 63 63 6f 72 64 69 | 6e 67 20 74 6f 20 74 68 |.accordi|ng to th|
|00003920| 65 20 63 75 72 72 65 6e | 74 20 63 68 61 72 61 63 |e curren|t charac|
|00003930| 74 65 72 20 73 65 74 20 | 6d 61 70 70 69 6e 67 20 |ter set |mapping |
|00003940| 28 74 68 65 20 64 65 66 | 61 75 6c 74 20 69 73 20 |(the def|ault is |
|00003950| 49 53 4f 2d 38 38 35 39 | 2d 31 0a 4c 61 74 69 6e |ISO-8859|-1.Latin|
|00003960| 31 29 2e 0a 40 00 6d 79 | 73 71 6c 3e 20 53 45 4c |1)..@.my|sql> SEL|
|00003970| 45 43 54 20 4c 4f 57 45 | 52 28 27 51 55 41 44 52 |ECT LOWE|R('QUADR|
|00003980| 41 54 49 43 41 4c 4c 59 | 27 29 3b 0a 20 20 20 20 |ATICALLY|');. |
|00003990| 20 20 20 20 2d 3e 20 27 | 71 75 61 64 72 61 74 69 | -> '|quadrati|
|000039a0| 63 61 6c 6c 79 27 00 00 | 01 01 41 22 23 00 00 00 |cally'..|..A"#...|
|000039b0| 01 25 0a 00 9c 00 20 20 | 20 4d 4f 44 28 40 76 61 |.%.... | MOD(@va|
|000039c0| 72 7b 4e 7d 2c 40 76 61 | 72 7b 4d 7d 29 0a 20 20 |r{N},@va|r{M}). |
|000039d0| 20 40 76 61 72 7b 4e 7d | 20 25 20 40 76 61 72 7b | @var{N}| % @var{|
|000039e0| 4d 7d 0a 20 20 20 40 76 | 61 72 7b 4e 7d 20 4d 4f |M}. @v|ar{N} MO|
|000039f0| 44 20 40 76 61 72 7b 4d | 7d 0a 4d 6f 64 75 6c 6f |D @var{M|}.Modulo|
|00003a00| 20 28 6c 69 6b 65 20 74 | 68 65 20 25 20 6f 70 65 | (like t|he % ope|
|00003a10| 72 61 74 6f 72 20 69 6e | 20 43 29 2e 0a 52 65 74 |rator in| C)..Ret|
|00003a20| 75 72 6e 73 20 74 68 65 | 20 72 65 6d 61 69 6e 64 |urns the| remaind|
|00003a30| 65 72 20 6f 66 20 40 76 | 61 72 7b 4e 7d 20 64 69 |er of @v|ar{N} di|
|00003a40| 76 69 64 65 64 20 62 79 | 20 40 76 61 72 7b 4d 7d |vided by| @var{M}|
|00003a50| 2e 0a 97 00 6d 79 73 71 | 6c 3e 20 53 45 4c 45 43 |....mysq|l> SELEC|
|00003a60| 54 20 4d 4f 44 28 32 33 | 34 2c 20 31 30 29 3b 0a |T MOD(23|4, 10);.|
|00003a70| 20 20 20 20 20 20 20 20 | 2d 3e 20 34 0a 6d 79 73 | |-> 4.mys|
|00003a80| 71 6c 3e 20 53 45 4c 45 | 43 54 20 32 35 33 20 25 |ql> SELE|CT 253 %|
|00003a90| 20 37 3b 0a 20 20 20 20 | 20 20 20 20 2d 3e 20 31 | 7;. | -> 1|
|00003aa0| 0a 6d 79 73 71 6c 3e 20 | 53 45 4c 45 43 54 20 4d |.mysql> |SELECT M|
|00003ab0| 4f 44 28 32 39 2c 39 29 | 3b 0a 20 20 20 20 20 20 |OD(29,9)|;. |
|00003ac0| 20 20 2d 3e 20 32 0a 6d | 79 73 71 6c 3e 20 53 45 | -> 2.m|ysql> SE|
|00003ad0| 4c 45 43 54 20 32 39 20 | 4d 4f 44 20 39 3b 0a 20 |LECT 29 |MOD 9;. |
|00003ae0| 20 20 20 20 20 20 20 2d | 3e 20 32 00 03 00 44 00 | -|> 2...D.|
|00003af0| 22 24 00 00 00 01 26 1c | 00 12 00 20 20 20 26 0a |"$....&.|... &.|
|00003b00| 42 69 74 77 69 73 65 20 | 41 4e 44 3a 0a 24 00 6d |Bitwise |AND:.$.m|
|00003b10| 79 73 71 6c 3e 20 53 45 | 4c 45 43 54 20 32 39 20 |ysql> SE|LECT 29 |
|00003b20| 26 20 31 35 3b 0a 20 20 | 20 20 20 20 20 20 2d 3e |& 15;. | ->|
|00003b30| 20 31 33 00 01 00 95 22 | 25 00 00 00 07 44 41 59 | 13...."|%....DAY|
|00003b40| 4e 41 4d 45 0f 00 47 00 | 20 20 20 44 41 59 4e 41 |NAME..G.| DAYNA|
|00003b50| 4d 45 28 40 76 61 72 7b | 64 61 74 65 7d 29 0a 52 |ME(@var{|date}).R|
|00003b60| 65 74 75 72 6e 73 20 74 | 68 65 20 6e 61 6d 65 20 |eturns t|he name |
|00003b70| 6f 66 20 74 68 65 20 77 | 65 65 6b 64 61 79 20 66 |of the w|eekday f|
|00003b80| 6f 72 20 40 76 61 72 7b | 64 61 74 65 7d 2e 0a 3a |or @var{|date}..:|
|00003b90| 00 6d 79 73 71 6c 3e 20 | 53 45 4c 45 43 54 20 44 |.mysql> |SELECT D|
|00003ba0| 41 59 4e 41 4d 45 28 27 | 31 39 39 38 2d 30 32 2d |AYNAME('|1998-02-|
|00003bb0| 30 35 27 29 3b 0a 20 20 | 20 20 20 20 20 20 2d 3e |05');. | ->|
|00003bc0| 20 27 54 68 75 72 73 64 | 61 79 27 00 03 00 68 00 | 'Thursd|ay'...h.|
|00003bd0| 22 26 00 00 00 07 2d 20 | 55 4e 41 52 59 0a 00 34 |"&....- |UNARY..4|
|00003be0| 00 20 20 20 2d 0a 55 6e | 61 72 79 20 6d 69 6e 75 |. -.Un|ary minu|
|00003bf0| 73 2e 20 43 68 61 6e 67 | 65 73 20 74 68 65 20 73 |s. Chang|es the s|
|00003c00| 69 67 6e 20 6f 66 20 74 | 68 65 20 61 72 67 75 6d |ign of t|he argum|
|00003c10| 65 6e 74 2e 0a 20 00 6d | 79 73 71 6c 3e 20 53 45 |ent.. .m|ysql> SE|
|00003c20| 4c 45 43 54 20 2d 20 32 | 3b 0a 20 20 20 20 20 20 |LECT - 2|;. |
|00003c30| 20 20 2d 3e 20 2d 32 00 | 01 12 25 32 27 00 00 00 | -> -2.|..%2'...|
|00003c40| 10 43 48 41 4e 47 45 20 | 4d 41 53 54 45 52 20 54 |.CHANGE |MASTER T|
|00003c50| 4f 1a 00 0a 12 0a 43 48 | 41 4e 47 45 20 4d 41 53 |O.....CH|ANGE MAS|
|00003c60| 54 45 52 20 54 4f 20 6d | 61 73 74 65 72 5f 64 65 |TER TO m|aster_de|
|00003c70| 66 20 5b 2c 20 6d 61 73 | 74 65 72 5f 64 65 66 5d |f [, mas|ter_def]|
|00003c80| 20 2e 2e 2e 0a 0a 6d 61 | 73 74 65 72 5f 64 65 66 | .....ma|ster_def|
|00003c90| 3a 0a 20 20 20 20 20 20 | 4d 41 53 54 45 52 5f 48 |:. |MASTER_H|
|00003ca0| 4f 53 54 20 3d 20 27 40 | 76 61 72 7b 68 6f 73 74 |OST = '@|var{host|
|00003cb0| 5f 6e 61 6d 65 7d 27 0a | 20 20 20 20 7c 20 4d 41 |_name}'.| | MA|
|00003cc0| 53 54 45 52 5f 55 53 45 | 52 20 3d 20 27 40 76 61 |STER_USE|R = '@va|
|00003cd0| 72 7b 75 73 65 72 5f 6e | 61 6d 65 7d 27 0a 20 20 |r{user_n|ame}'. |
|00003ce0| 20 20 7c 20 4d 41 53 54 | 45 52 5f 50 41 53 53 57 | | MAST|ER_PASSW|
|00003cf0| 4f 52 44 20 3d 20 27 40 | 76 61 72 7b 70 61 73 73 |ORD = '@|var{pass|
|00003d00| 77 6f 72 64 7d 27 0a 20 | 20 20 20 7c 20 4d 41 53 |word}'. | | MAS|
|00003d10| 54 45 52 5f 50 4f 52 54 | 20 3d 20 40 76 61 72 7b |TER_PORT| = @var{|
|00003d20| 70 6f 72 74 5f 6e 75 6d | 7d 0a 20 20 20 20 7c 20 |port_num|}. | |
|00003d30| 4d 41 53 54 45 52 5f 43 | 4f 4e 4e 45 43 54 5f 52 |MASTER_C|ONNECT_R|
|00003d40| 45 54 52 59 20 3d 20 40 | 76 61 72 7b 63 6f 75 6e |ETRY = @|var{coun|
|00003d50| 74 7d 0a 20 20 20 20 7c | 20 4d 41 53 54 45 52 5f |t}. || MASTER_|
|00003d60| 4c 4f 47 5f 46 49 4c 45 | 20 3d 20 27 40 76 61 72 |LOG_FILE| = '@var|
|00003d70| 7b 6d 61 73 74 65 72 5f | 6c 6f 67 5f 6e 61 6d 65 |{master_|log_name|
|00003d80| 7d 27 0a 20 20 20 20 7c | 20 4d 41 53 54 45 52 5f |}'. || MASTER_|
|00003d90| 4c 4f 47 5f 50 4f 53 20 | 3d 20 40 76 61 72 7b 6d |LOG_POS |= @var{m|
|00003da0| 61 73 74 65 72 5f 6c 6f | 67 5f 70 6f 73 7d 0a 20 |aster_lo|g_pos}. |
|00003db0| 20 20 20 7c 20 52 45 4c | 41 59 5f 4c 4f 47 5f 46 | | REL|AY_LOG_F|
|00003dc0| 49 4c 45 20 3d 20 27 40 | 76 61 72 7b 72 65 6c 61 |ILE = '@|var{rela|
|00003dd0| 79 5f 6c 6f 67 5f 6e 61 | 6d 65 7d 27 0a 20 20 20 |y_log_na|me}'. |
|00003de0| 20 7c 20 52 45 4c 41 59 | 5f 4c 4f 47 5f 50 4f 53 | | RELAY|_LOG_POS|
|00003df0| 20 3d 20 40 76 61 72 7b | 72 65 6c 61 79 5f 6c 6f | = @var{|relay_lo|
|00003e00| 67 5f 70 6f 73 7d 0a 20 | 20 20 20 7c 20 4d 41 53 |g_pos}. | | MAS|
|00003e10| 54 45 52 5f 53 53 4c 20 | 3d 20 7b 30 7c 31 7d 0a |TER_SSL |= {0|1}.|
|00003e20| 20 20 20 20 7c 20 4d 41 | 53 54 45 52 5f 53 53 4c | | MA|STER_SSL|
|00003e30| 5f 43 41 20 3d 20 27 40 | 76 61 72 7b 63 61 5f 66 |_CA = '@|var{ca_f|
|00003e40| 69 6c 65 5f 6e 61 6d 65 | 7d 27 0a 20 20 20 20 7c |ile_name|}'. ||
|00003e50| 20 4d 41 53 54 45 52 5f | 53 53 4c 5f 43 41 50 41 | MASTER_|SSL_CAPA|
|00003e60| 54 48 20 3d 20 27 40 76 | 61 72 7b 63 61 5f 64 69 |TH = '@v|ar{ca_di|
|00003e70| 72 65 63 74 6f 72 79 5f | 6e 61 6d 65 7d 27 0a 20 |rectory_|name}'. |
|00003e80| 20 20 20 7c 20 4d 41 53 | 54 45 52 5f 53 53 4c 5f | | MAS|TER_SSL_|
|00003e90| 43 45 52 54 20 3d 20 27 | 40 76 61 72 7b 63 65 72 |CERT = '|@var{cer|
|00003ea0| 74 5f 66 69 6c 65 5f 6e | 61 6d 65 7d 27 0a 20 20 |t_file_n|ame}'. |
|00003eb0| 20 20 7c 20 4d 41 53 54 | 45 52 5f 53 53 4c 5f 4b | | MAST|ER_SSL_K|
|00003ec0| 45 59 20 3d 20 27 40 76 | 61 72 7b 6b 65 79 5f 66 |EY = '@v|ar{key_f|
|00003ed0| 69 6c 65 5f 6e 61 6d 65 | 7d 27 0a 20 20 20 20 7c |ile_name|}'. ||
|00003ee0| 20 4d 41 53 54 45 52 5f | 53 53 4c 5f 43 49 50 48 | MASTER_|SSL_CIPH|
|00003ef0| 45 52 20 3d 20 27 40 76 | 61 72 7b 63 69 70 68 65 |ER = '@v|ar{ciphe|
|00003f00| 72 5f 6c 69 73 74 7d 27 | 0a 0a 43 68 61 6e 67 65 |r_list}'|..Change|
|00003f10| 73 20 74 68 65 20 70 61 | 72 61 6d 65 74 65 72 73 |s the pa|rameters|
|00003f20| 20 74 68 61 74 20 74 68 | 65 20 73 6c 61 76 65 20 | that th|e slave |
|00003f30| 73 65 72 76 65 72 20 75 | 73 65 73 20 66 6f 72 20 |server u|ses for |
|00003f40| 63 6f 6e 6e 65 63 74 69 | 6e 67 20 74 6f 20 61 6e |connecti|ng to an|
|00003f50| 64 0a 63 6f 6d 6d 75 6e | 69 63 61 74 69 6e 67 20 |d.commun|icating |
|00003f60| 77 69 74 68 20 74 68 65 | 20 6d 61 73 74 65 72 20 |with the| master |
|00003f70| 73 65 72 76 65 72 2e 0a | 0a 4d 41 53 54 45 52 5f |server..|.MASTER_|
|00003f80| 55 53 45 52 2c 20 4d 41 | 53 54 45 52 5f 50 41 53 |USER, MA|STER_PAS|
|00003f90| 53 57 4f 52 44 2c 20 4d | 41 53 54 45 52 5f 53 53 |SWORD, M|ASTER_SS|
|00003fa0| 4c 2c 0a 4d 41 53 54 45 | 52 5f 53 53 4c 5f 43 41 |L,.MASTE|R_SSL_CA|
|00003fb0| 2c 20 4d 41 53 54 45 52 | 5f 53 53 4c 5f 43 41 50 |, MASTER|_SSL_CAP|
|00003fc0| 41 54 48 2c 20 4d 41 53 | 54 45 52 5f 53 53 4c 5f |ATH, MAS|TER_SSL_|
|00003fd0| 43 45 52 54 2c 0a 4d 41 | 53 54 45 52 5f 53 53 4c |CERT,.MA|STER_SSL|
|00003fe0| 5f 4b 45 59 2c 20 61 6e | 64 20 4d 41 53 54 45 52 |_KEY, an|d MASTER|
|00003ff0| 5f 53 53 4c 5f 43 49 50 | 48 45 52 20 70 72 6f 76 |_SSL_CIP|HER prov|
|00004000| 69 64 65 20 69 6e 66 6f | 72 6d 61 74 69 6f 6e 20 |ide info|rmation |
|00004010| 66 6f 72 0a 74 68 65 20 | 73 6c 61 76 65 20 61 62 |for.the |slave ab|
|00004020| 6f 75 74 20 68 6f 77 20 | 74 6f 20 63 6f 6e 6e 65 |out how |to conne|
|00004030| 63 74 20 74 6f 20 69 74 | 73 20 6d 61 73 74 65 72 |ct to it|s master|
|00004040| 2e 0a 0a 54 68 65 20 72 | 65 6c 61 79 20 6c 6f 67 |...The r|elay log|
|00004050| 20 6f 70 74 69 6f 6e 73 | 20 28 52 45 4c 41 59 5f | options| (RELAY_|
|00004060| 4c 4f 47 5f 46 49 4c 45 | 20 61 6e 64 20 52 45 4c |LOG_FILE| and REL|
|00004070| 41 59 5f 4c 4f 47 5f 50 | 4f 53 29 20 61 72 65 0a |AY_LOG_P|OS) are.|
|00004080| 61 76 61 69 6c 61 62 6c | 65 20 62 65 67 69 6e 6e |availabl|e beginn|
|00004090| 69 6e 67 20 77 69 74 68 | 20 4d 79 53 51 4c 20 34 |ing with| MySQL 4|
|000040a0| 2e 30 2e 0a 0a 54 68 65 | 20 53 53 4c 20 6f 70 74 |.0...The| SSL opt|
|000040b0| 69 6f 6e 73 0a 28 4d 41 | 53 54 45 52 5f 53 53 4c |ions.(MA|STER_SSL|
|000040c0| 2c 0a 4d 41 53 54 45 52 | 5f 53 53 4c 5f 43 41 2c |,.MASTER|_SSL_CA,|
|000040d0| 0a 4d 41 53 54 45 52 5f | 53 53 4c 5f 43 41 50 41 |.MASTER_|SSL_CAPA|
|000040e0| 54 48 2c 0a 4d 41 53 54 | 45 52 5f 53 53 4c 5f 43 |TH,.MAST|ER_SSL_C|
|000040f0| 45 52 54 2c 0a 4d 41 53 | 54 45 52 5f 53 53 4c 5f |ERT,.MAS|TER_SSL_|
|00004100| 4b 45 59 2c 0a 61 6e 64 | 0a 4d 41 53 54 45 52 5f |KEY,.and|.MASTER_|
|00004110| 53 53 4c 5f 43 49 50 48 | 45 52 29 0a 61 72 65 20 |SSL_CIPH|ER).are |
|00004120| 61 76 61 69 6c 61 62 6c | 65 20 62 65 67 69 6e 6e |availabl|e beginn|
|00004130| 69 6e 67 20 77 69 74 68 | 20 4d 79 53 51 4c 20 34 |ing with| MySQL 4|
|00004140| 2e 31 2e 31 2e 0a 59 6f | 75 20 63 61 6e 20 63 68 |.1.1..Yo|u can ch|
|00004150| 61 6e 67 65 20 74 68 65 | 73 65 20 6f 70 74 69 6f |ange the|se optio|
|00004160| 6e 73 20 65 76 65 6e 20 | 6f 6e 20 73 6c 61 76 65 |ns even |on slave|
|00004170| 73 20 74 68 61 74 20 61 | 72 65 20 63 6f 6d 70 69 |s that a|re compi|
|00004180| 6c 65 64 20 77 69 74 68 | 6f 75 74 20 53 53 4c 0a |led with|out SSL.|
|00004190| 73 75 70 70 6f 72 74 2e | 20 54 68 65 79 20 61 72 |support.| They ar|
|000041a0| 65 20 73 61 76 65 64 20 | 74 6f 20 74 68 65 20 2a |e saved |to the *|
|000041b0| 6d 61 73 74 65 72 2e 69 | 6e 66 6f 20 66 69 6c 65 |master.i|nfo file|
|000041c0| 2c 20 62 75 74 20 69 73 | 20 69 67 6e 6f 72 65 64 |, but is| ignored|
|000041d0| 0a 75 6e 74 69 6c 20 79 | 6f 75 20 75 73 65 20 61 |.until y|ou use a|
|000041e0| 20 73 65 72 76 65 72 20 | 74 68 61 74 20 68 61 73 | server |that has|
|000041f0| 20 53 53 4c 20 73 75 70 | 70 6f 72 74 20 65 6e 61 | SSL sup|port ena|
|00004200| 62 6c 65 64 2e 0a 0a 49 | 66 20 79 6f 75 20 64 6f |bled...I|f you do|
|00004210| 6e 27 74 20 73 70 65 63 | 69 66 79 20 61 20 67 69 |n't spec|ify a gi|
|00004220| 76 65 6e 20 70 61 72 61 | 6d 65 74 65 72 2c 20 69 |ven para|meter, i|
|00004230| 74 20 6b 65 65 70 73 20 | 69 74 73 20 6f 6c 64 0a |t keeps |its old.|
|00004240| 76 61 6c 75 65 2c 20 65 | 78 63 65 70 74 20 61 73 |value, e|xcept as|
|00004250| 20 69 6e 64 69 63 61 74 | 65 64 20 69 6e 20 74 68 | indicat|ed in th|
|00004260| 65 20 66 6f 6c 6c 6f 77 | 69 6e 67 20 64 69 73 63 |e follow|ing disc|
|00004270| 75 73 73 69 6f 6e 2e 20 | 46 6f 72 20 65 78 61 6d |ussion. |For exam|
|00004280| 70 6c 65 2c 20 69 66 20 | 74 68 65 20 70 61 73 73 |ple, if |the pass|
|00004290| 77 6f 72 64 20 74 6f 20 | 63 6f 6e 6e 65 63 74 20 |word to |connect |
|000042a0| 74 6f 20 79 6f 75 72 20 | 4d 79 53 51 4c 20 6d 61 |to your |MySQL ma|
|000042b0| 73 74 65 72 20 68 61 73 | 0a 63 68 61 6e 67 65 64 |ster has|.changed|
|000042c0| 2c 20 79 6f 75 20 6a 75 | 73 74 20 6e 65 65 64 20 |, you ju|st need |
|000042d0| 74 6f 20 69 73 73 75 65 | 20 74 68 65 73 65 20 73 |to issue| these s|
|000042e0| 74 61 74 65 6d 65 6e 74 | 73 0a 74 6f 20 74 65 6c |tatement|s.to tel|
|000042f0| 6c 20 74 68 65 20 73 6c | 61 76 65 20 61 62 6f 75 |l the sl|ave abou|
|00004300| 74 20 74 68 65 20 6e 65 | 77 20 70 61 73 73 77 6f |t the ne|w passwo|
|00004310| 72 64 3a 0a 0a 6d 79 73 | 71 6c 3e 20 53 54 4f 50 |rd:..mys|ql> STOP|
|00004320| 20 53 4c 41 56 45 3b 20 | 2d 2d 20 69 66 20 72 65 | SLAVE; |-- if re|
|00004330| 70 6c 69 63 61 74 69 6f | 6e 20 77 61 73 20 72 75 |plicatio|n was ru|
|00004340| 6e 6e 69 6e 67 0a 6d 79 | 73 71 6c 3e 20 43 48 41 |nning.my|sql> CHA|
|00004350| 4e 47 45 20 4d 41 53 54 | 45 52 20 54 4f 20 4d 41 |NGE MAST|ER TO MA|
|00004360| 53 54 45 52 5f 50 41 53 | 53 57 4f 52 44 3d 27 6e |STER_PAS|SWORD='n|
|00004370| 65 77 33 63 72 65 74 27 | 3b 0a 6d 79 73 71 6c 3e |ew3cret'|;.mysql>|
|00004380| 20 53 54 41 52 54 20 53 | 4c 41 56 45 3b 20 2d 2d | START S|LAVE; --|
|00004390| 20 69 66 20 79 6f 75 20 | 77 61 6e 74 20 74 6f 20 | if you |want to |
|000043a0| 72 65 73 74 61 72 74 20 | 72 65 70 6c 69 63 61 74 |restart |replicat|
|000043b0| 69 6f 6e 0a 0a 54 68 65 | 72 65 20 69 73 20 6e 6f |ion..The|re is no|
|000043c0| 20 6e 65 65 64 20 74 6f | 20 73 70 65 63 69 66 79 | need to| specify|
|000043d0| 20 74 68 65 20 70 61 72 | 61 6d 65 74 65 72 73 20 | the par|ameters |
|000043e0| 74 68 61 74 20 64 6f 0a | 6e 6f 74 20 63 68 61 6e |that do.|not chan|
|000043f0| 67 65 20 28 68 6f 73 74 | 2c 20 70 6f 72 74 2c 20 |ge (host|, port, |
|00004400| 75 73 65 72 2c 20 61 6e | 64 20 73 6f 20 66 6f 72 |user, an|d so for|
|00004410| 74 68 29 2e 0a 0a 4d 41 | 53 54 45 52 5f 48 4f 53 |th)...MA|STER_HOS|
|00004420| 54 20 61 6e 64 20 4d 41 | 53 54 45 52 5f 50 4f 52 |T and MA|STER_POR|
|00004430| 54 20 61 72 65 20 74 68 | 65 20 68 6f 73 74 6e 61 |T are th|e hostna|
|00004440| 6d 65 20 28 6f 72 20 49 | 50 20 61 64 64 72 65 73 |me (or I|P addres|
|00004450| 73 29 20 6f 66 0a 74 68 | 65 20 6d 61 73 74 65 72 |s) of.th|e master|
|00004460| 20 68 6f 73 74 20 61 6e | 64 20 69 74 73 20 54 43 | host an|d its TC|
|00004470| 50 2f 49 50 20 70 6f 72 | 74 2e 20 4e 6f 74 65 20 |P/IP por|t. Note |
|00004480| 74 68 61 74 20 69 66 20 | 4d 41 53 54 45 52 5f 48 |that if |MASTER_H|
|00004490| 4f 53 54 20 69 73 0a 65 | 71 75 61 6c 20 74 6f 20 |OST is.e|qual to |
|000044a0| 6c 6f 63 61 6c 68 6f 73 | 74 2c 20 74 68 65 6e 2c |localhos|t, then,|
|000044b0| 20 6c 69 6b 65 20 69 6e | 20 6f 74 68 65 72 20 70 | like in| other p|
|000044c0| 61 72 74 73 20 6f 66 20 | 4d 79 53 51 4c 2c 20 74 |arts of |MySQL, t|
|000044d0| 68 65 20 70 6f 72 74 0a | 6d 61 79 20 62 65 20 69 |he port.|may be i|
|000044e0| 67 6e 6f 72 65 64 20 28 | 69 66 20 55 6e 69 78 20 |gnored (|if Unix |
|000044f0| 73 6f 63 6b 65 74 20 66 | 69 6c 65 73 20 63 61 6e |socket f|iles can|
|00004500| 20 62 65 20 75 73 65 64 | 2c 20 66 6f 72 20 65 78 | be used|, for ex|
|00004510| 61 6d 70 6c 65 29 2e 0a | 0a 49 66 20 79 6f 75 20 |ample)..|.If you |
|00004520| 73 70 65 63 69 66 79 20 | 4d 41 53 54 45 52 5f 48 |specify |MASTER_H|
|00004530| 4f 53 54 20 6f 72 20 4d | 41 53 54 45 52 5f 50 4f |OST or M|ASTER_PO|
|00004540| 52 54 2c 0a 74 68 65 20 | 73 6c 61 76 65 20 61 73 |RT,.the |slave as|
|00004550| 73 75 6d 65 73 20 74 68 | 61 74 20 74 68 65 20 6d |sumes th|at the m|
|00004560| 61 73 74 65 72 20 73 65 | 72 76 65 72 20 69 73 20 |aster se|rver is |
|00004570| 64 69 66 66 65 72 65 6e | 74 20 74 68 61 6e 0a 62 |differen|t than.b|
|00004580| 65 66 6f 72 65 20 28 65 | 76 65 6e 20 69 66 20 79 |efore (e|ven if y|
|00004590| 6f 75 20 73 70 65 63 69 | 66 79 20 61 20 68 6f 73 |ou speci|fy a hos|
|000045a0| 74 20 6f 72 20 70 6f 72 | 74 20 76 61 6c 75 65 20 |t or por|t value |
|000045b0| 74 68 61 74 20 69 73 0a | 74 68 65 20 73 61 6d 65 |that is.|the same|
|000045c0| 20 61 73 20 74 68 65 20 | 63 75 72 72 65 6e 74 20 | as the |current |
|000045d0| 76 61 6c 75 65 2e 29 20 | 49 6e 20 74 68 69 73 20 |value.) |In this |
|000045e0| 63 61 73 65 2c 20 74 68 | 65 20 6f 6c 64 20 76 61 |case, th|e old va|
|000045f0| 6c 75 65 73 20 66 6f 72 | 20 74 68 65 20 6d 61 73 |lues for| the mas|
|00004600| 74 65 72 0a 62 69 6e 61 | 72 79 20 6c 6f 67 20 6e |ter.bina|ry log n|
|00004610| 61 6d 65 20 61 6e 64 20 | 70 6f 73 69 74 69 6f 6e |ame and |position|
|00004620| 20 61 72 65 20 63 6f 6e | 73 69 64 65 72 65 64 20 | are con|sidered |
|00004630| 6e 6f 20 6c 6f 6e 67 65 | 72 20 61 70 70 6c 69 63 |no longe|r applic|
|00004640| 61 62 6c 65 2c 20 73 6f | 20 69 66 20 79 6f 75 0a |able, so| if you.|
|00004650| 64 6f 20 6e 6f 74 20 73 | 70 65 63 69 66 79 20 4d |do not s|pecify M|
|00004660| 41 53 54 45 52 5f 4c 4f | 47 5f 46 49 4c 45 20 61 |ASTER_LO|G_FILE a|
|00004670| 6e 64 20 4d 41 53 54 45 | 52 5f 4c 4f 47 5f 50 4f |nd MASTE|R_LOG_PO|
|00004680| 53 20 69 6e 20 74 68 65 | 0a 73 74 61 74 65 6d 65 |S in the|.stateme|
|00004690| 6e 74 2c 20 4d 41 53 54 | 45 52 5f 4c 4f 47 5f 46 |nt, MAST|ER_LOG_F|
|000046a0| 49 4c 45 3d 27 27 20 61 | 6e 64 20 4d 41 53 54 45 |ILE='' a|nd MASTE|
|000046b0| 52 5f 4c 4f 47 5f 50 4f | 53 3d 34 20 61 72 65 0a |R_LOG_PO|S=4 are.|
|000046c0| 73 69 6c 65 6e 74 6c 79 | 20 61 70 70 65 6e 64 65 |silently| appende|
|000046d0| 64 20 74 6f 20 69 74 2e | 20 0a 0a 4d 41 53 54 45 |d to it.| ..MASTE|
|000046e0| 52 5f 4c 4f 47 5f 46 49 | 4c 45 20 61 6e 64 20 4d |R_LOG_FI|LE and M|
|000046f0| 41 53 54 45 52 5f 4c 4f | 47 5f 50 4f 53 20 61 72 |ASTER_LO|G_POS ar|
|00004700| 65 20 74 68 65 20 63 6f | 6f 72 64 69 6e 61 74 65 |e the co|ordinate|
|00004710| 73 0a 61 74 20 77 68 69 | 63 68 20 74 68 65 20 73 |s.at whi|ch the s|
|00004720| 6c 61 76 65 20 49 2f 4f | 20 74 68 72 65 61 64 20 |lave I/O| thread |
|00004730| 73 68 6f 75 6c 64 20 62 | 65 67 69 6e 20 72 65 61 |should b|egin rea|
|00004740| 64 69 6e 67 20 66 72 6f | 6d 20 74 68 65 20 6d 61 |ding fro|m the ma|
|00004750| 73 74 65 72 20 74 68 65 | 0a 6e 65 78 74 20 74 69 |ster the|.next ti|
|00004760| 6d 65 20 74 68 65 20 74 | 68 72 65 61 64 20 73 74 |me the t|hread st|
|00004770| 61 72 74 73 2e 0a 49 66 | 20 79 6f 75 20 73 70 65 |arts..If| you spe|
|00004780| 63 69 66 79 20 65 69 74 | 68 65 72 20 6f 66 20 74 |cify eit|her of t|
|00004790| 68 65 6d 2c 20 79 6f 75 | 20 63 61 6e 27 74 20 73 |hem, you| can't s|
|000047a0| 70 65 63 69 66 79 20 52 | 45 4c 41 59 5f 4c 4f 47 |pecify R|ELAY_LOG|
|000047b0| 5f 46 49 4c 45 20 6f 72 | 0a 52 45 4c 41 59 5f 4c |_FILE or|.RELAY_L|
|000047c0| 4f 47 5f 50 4f 53 2e 0a | 49 66 20 6e 65 69 74 68 |OG_POS..|If neith|
|000047d0| 65 72 20 6f 66 20 4d 41 | 53 54 45 52 5f 4c 4f 47 |er of MA|STER_LOG|
|000047e0| 5f 46 49 4c 45 20 6f 72 | 20 4d 41 53 54 45 52 5f |_FILE or| MASTER_|
|000047f0| 4c 4f 47 5f 50 4f 53 20 | 61 72 65 0a 73 70 65 63 |LOG_POS |are.spec|
|00004800| 69 66 69 65 64 2c 20 74 | 68 65 20 73 6c 61 76 65 |ified, t|he slave|
|00004810| 20 75 73 65 73 20 74 68 | 65 20 6c 61 73 74 20 63 | uses th|e last c|
|00004820| 6f 6f 72 64 69 6e 61 74 | 65 73 20 6f 66 20 74 68 |oordinat|es of th|
|00004830| 65 20 2f 73 6c 61 76 65 | 20 53 51 4c 20 74 68 72 |e /slave| SQL thr|
|00004840| 65 61 64 2f 0a 62 65 66 | 6f 72 65 20 43 48 41 4e |ead/.bef|ore CHAN|
|00004850| 47 45 20 4d 41 53 54 45 | 52 20 77 61 73 20 69 73 |GE MASTE|R was is|
|00004860| 73 75 65 64 2e 20 54 68 | 69 73 20 65 6e 73 75 72 |sued. Th|is ensur|
|00004870| 65 73 20 74 68 61 74 0a | 72 65 70 6c 69 63 61 74 |es that.|replicat|
|00004880| 69 6f 6e 20 68 61 73 20 | 6e 6f 20 64 69 73 63 6f |ion has |no disco|
|00004890| 6e 74 69 6e 75 69 74 79 | 2c 20 65 76 65 6e 20 69 |ntinuity|, even i|
|000048a0| 66 20 74 68 65 20 73 6c | 61 76 65 20 53 51 4c 20 |f the sl|ave SQL |
|000048b0| 74 68 72 65 61 64 20 77 | 61 73 20 6c 61 74 65 0a |thread w|as late.|
|000048c0| 63 6f 6d 70 61 72 65 64 | 20 74 6f 20 74 68 65 20 |compared| to the |
|000048d0| 73 6c 61 76 65 20 49 2f | 4f 20 74 68 72 65 61 64 |slave I/|O thread|
|000048e0| 2c 20 77 68 65 6e 20 79 | 6f 75 20 6a 75 73 74 20 |, when y|ou just |
|000048f0| 77 61 6e 74 20 74 6f 20 | 63 68 61 6e 67 65 2c 20 |want to |change, |
|00004900| 73 61 79 2c 20 74 68 65 | 0a 70 61 73 73 77 6f 72 |say, the|.passwor|
|00004910| 64 20 74 6f 20 75 73 65 | 2e 20 54 68 69 73 20 73 |d to use|. This s|
|00004920| 61 66 65 20 62 65 68 61 | 76 69 6f 72 20 77 61 73 |afe beha|vior was|
|00004930| 20 69 6e 74 72 6f 64 75 | 63 65 64 20 73 74 61 72 | introdu|ced star|
|00004940| 74 69 6e 67 20 66 72 6f | 6d 20 4d 79 53 51 4c 0a |ting fro|m MySQL.|
|00004950| 34 2e 30 2e 31 37 20 61 | 6e 64 20 34 2e 31 2e 31 |4.0.17 a|nd 4.1.1|
|00004960| 2e 20 28 42 65 66 6f 72 | 65 20 74 68 65 73 65 20 |. (Befor|e these |
|00004970| 76 65 72 73 69 6f 6e 73 | 2c 20 74 68 65 20 63 6f |versions|, the co|
|00004980| 6f 72 64 69 6e 61 74 65 | 73 20 75 73 65 64 20 77 |ordinate|s used w|
|00004990| 65 72 65 20 0a 74 68 65 | 20 6c 61 73 74 20 63 6f |ere .the| last co|
|000049a0| 6f 72 64 69 6e 61 74 65 | 73 20 6f 66 20 74 68 65 |ordinate|s of the|
|000049b0| 20 73 6c 61 76 65 20 49 | 2f 4f 20 74 68 72 65 61 | slave I|/O threa|
|000049c0| 64 20 62 65 66 6f 72 65 | 20 43 48 41 4e 47 45 20 |d before| CHANGE |
|000049d0| 4d 41 53 54 45 52 0a 77 | 61 73 20 69 73 73 75 65 |MASTER.w|as issue|
|000049e0| 64 2e 20 54 68 69 73 20 | 63 61 75 73 65 64 20 74 |d. This |caused t|
|000049f0| 68 65 20 53 51 4c 20 74 | 68 72 65 61 64 20 74 6f |he SQL t|hread to|
|00004a00| 20 70 6f 73 73 69 62 6c | 79 20 6c 6f 73 65 20 73 | possibl|y lose s|
|00004a10| 6f 6d 65 20 65 76 65 6e | 74 73 0a 66 72 6f 6d 20 |ome even|ts.from |
|00004a20| 74 68 65 20 6d 61 73 74 | 65 72 2c 20 74 68 75 73 |the mast|er, thus|
|00004a30| 20 62 72 65 61 6b 69 6e | 67 20 72 65 70 6c 69 63 | breakin|g replic|
|00004a40| 61 74 69 6f 6e 2e 29 0a | 0a 43 48 41 4e 47 45 20 |ation.).|.CHANGE |
|00004a50| 4d 41 53 54 45 52 20 2f | 64 65 6c 65 74 65 73 20 |MASTER /|deletes |
|00004a60| 61 6c 6c 20 72 65 6c 61 | 79 20 6c 6f 67 20 66 69 |all rela|y log fi|
|00004a70| 6c 65 73 2f 20 61 6e 64 | 20 73 74 61 72 74 73 0a |les/ and| starts.|
|00004a80| 61 20 6e 65 77 20 6f 6e | 65 2c 20 75 6e 6c 65 73 |a new on|e, unles|
|00004a90| 73 20 79 6f 75 20 73 70 | 65 63 69 66 79 20 52 45 |s you sp|ecify RE|
|00004aa0| 4c 41 59 5f 4c 4f 47 5f | 46 49 4c 45 20 6f 72 0a |LAY_LOG_|FILE or.|
|00004ab0| 52 45 4c 41 59 5f 4c 4f | 47 5f 50 4f 53 2e 20 49 |RELAY_LO|G_POS. I|
|00004ac0| 6e 20 74 68 61 74 20 63 | 61 73 65 2c 20 72 65 6c |n that c|ase, rel|
|00004ad0| 61 79 20 6c 6f 67 73 20 | 61 72 65 20 6b 65 70 74 |ay logs |are kept|
|00004ae0| 3b 0a 61 73 20 6f 66 20 | 4d 79 53 51 4c 20 34 2e |;.as of |MySQL 4.|
|00004af0| 31 2e 31 20 74 68 65 20 | 72 65 6c 61 79 5f 6c 6f |1.1 the |relay_lo|
|00004b00| 67 5f 70 75 72 67 65 20 | 67 6c 6f 62 61 6c 20 76 |g_purge |global v|
|00004b10| 61 72 69 61 62 6c 65 0a | 69 73 20 73 65 74 20 73 |ariable.|is set s|
|00004b20| 69 6c 65 6e 74 6c 79 20 | 74 6f 20 30 2e 0a 0a 43 |ilently |to 0...C|
|00004b30| 48 41 4e 47 45 20 4d 41 | 53 54 45 52 20 54 4f 20 |HANGE MA|STER TO |
|00004b40| 75 70 64 61 74 65 73 20 | 74 68 65 20 63 6f 6e 74 |updates |the cont|
|00004b50| 65 6e 74 73 20 6f 66 20 | 74 68 65 20 2a 6d 61 73 |ents of |the *mas|
|00004b60| 74 65 72 2e 69 6e 66 6f | 20 61 6e 64 0a 2a 72 65 |ter.info| and.*re|
|00004b70| 6c 61 79 2d 6c 6f 67 2e | 69 6e 66 6f 20 66 69 6c |lay-log.|info fil|
|00004b80| 65 73 2e 0a 0a 43 48 41 | 4e 47 45 20 4d 41 53 54 |es...CHA|NGE MAST|
|00004b90| 45 52 20 69 73 20 75 73 | 65 66 75 6c 20 66 6f 72 |ER is us|eful for|
|00004ba0| 20 73 65 74 74 69 6e 67 | 20 75 70 20 61 20 73 6c | setting| up a sl|
|00004bb0| 61 76 65 20 77 68 65 6e | 20 79 6f 75 20 68 61 76 |ave when| you hav|
|00004bc0| 65 0a 74 68 65 20 73 6e | 61 70 73 68 6f 74 20 6f |e.the sn|apshot o|
|00004bd0| 66 20 74 68 65 20 6d 61 | 73 74 65 72 20 61 6e 64 |f the ma|ster and|
|00004be0| 20 68 61 76 65 20 72 65 | 63 6f 72 64 65 64 20 74 | have re|corded t|
|00004bf0| 68 65 20 6c 6f 67 20 61 | 6e 64 20 74 68 65 20 6f |he log a|nd the o|
|00004c00| 66 66 73 65 74 0a 63 6f | 72 72 65 73 70 6f 6e 64 |ffset.co|rrespond|
|00004c10| 69 6e 67 20 74 6f 20 69 | 74 2e 20 20 41 66 74 65 |ing to i|t. Afte|
|00004c20| 72 20 6c 6f 61 64 69 6e | 67 20 74 68 65 20 73 6e |r loadin|g the sn|
|00004c30| 61 70 73 68 6f 74 20 69 | 6e 74 6f 20 74 68 65 20 |apshot i|nto the |
|00004c40| 73 6c 61 76 65 2c 20 79 | 6f 75 0a 63 61 6e 20 72 |slave, y|ou.can r|
|00004c50| 75 6e 20 43 48 41 4e 47 | 45 20 4d 41 53 54 45 52 |un CHANG|E MASTER|
|00004c60| 20 54 4f 20 4d 41 53 54 | 45 52 5f 4c 4f 47 5f 46 | TO MAST|ER_LOG_F|
|00004c70| 49 4c 45 3d 27 40 76 61 | 72 7b 6c 6f 67 5f 6e 61 |ILE='@va|r{log_na|
|00004c80| 6d 65 5f 6f 6e 5f 6d 61 | 73 74 65 72 27 2c 0a 4d |me_on_ma|ster',.M|
|00004c90| 41 53 54 45 52 5f 4c 4f | 47 5f 50 4f 53 3d 40 76 |ASTER_LO|G_POS=@v|
|00004ca0| 61 72 7b 6c 6f 67 5f 6f | 66 66 73 65 74 5f 6f 6e |ar{log_o|ffset_on|
|00004cb0| 5f 6d 61 73 74 65 72 7d | 7d 20 6f 6e 20 74 68 65 |_master}|} on the|
|00004cc0| 20 73 6c 61 76 65 2e 0a | 0a 45 78 61 6d 70 6c 65 | slave..|.Example|
|00004cd0| 73 3a 0a 0a 6d 79 73 71 | 6c 3e 20 43 48 41 4e 47 |s:..mysq|l> CHANG|
|00004ce0| 45 20 4d 41 53 54 45 52 | 20 54 4f 0a 20 20 20 20 |E MASTER| TO. |
|00004cf0| 2d 3e 20 20 20 20 20 4d | 41 53 54 45 52 5f 48 4f |-> M|ASTER_HO|
|00004d00| 53 54 3d 27 6d 61 73 74 | 65 72 32 2e 6d 79 63 6f |ST='mast|er2.myco|
|00004d10| 6d 70 61 6e 79 2e 63 6f | 6d 27 2c 0a 20 20 20 20 |mpany.co|m',. |
|00004d20| 2d 3e 20 20 20 20 20 4d | 41 53 54 45 52 5f 55 53 |-> M|ASTER_US|
|00004d30| 45 52 3d 27 72 65 70 6c | 69 63 61 74 69 6f 6e 27 |ER='repl|ication'|
|00004d40| 2c 0a 20 20 20 20 2d 3e | 20 20 20 20 20 4d 41 53 |,. ->| MAS|
|00004d50| 54 45 52 5f 50 41 53 53 | 57 4f 52 44 3d 27 62 69 |TER_PASS|WORD='bi|
|00004d60| 67 73 33 63 72 65 74 27 | 2c 0a 20 20 20 20 2d 3e |gs3cret'|,. ->|
|00004d70| 20 20 20 20 20 4d 41 53 | 54 45 52 5f 50 4f 52 54 | MAS|TER_PORT|
|00004d80| 3d 33 33 30 36 2c 0a 20 | 20 20 20 2d 3e 20 20 20 |=3306,. | -> |
|00004d90| 20 20 4d 41 53 54 45 52 | 5f 4c 4f 47 5f 46 49 4c | MASTER|_LOG_FIL|
|00004da0| 45 3d 27 6d 61 73 74 65 | 72 32 2d 62 69 6e 2e 30 |E='maste|r2-bin.0|
|00004db0| 30 31 27 2c 0a 20 20 20 | 20 2d 3e 20 20 20 20 20 |01',. | -> |
|00004dc0| 4d 41 53 54 45 52 5f 4c | 4f 47 5f 50 4f 53 3d 34 |MASTER_L|OG_POS=4|
|00004dd0| 2c 0a 20 20 20 20 2d 3e | 20 20 20 20 20 4d 41 53 |,. ->| MAS|
|00004de0| 54 45 52 5f 43 4f 4e 4e | 45 43 54 5f 52 45 54 52 |TER_CONN|ECT_RETR|
|00004df0| 59 3d 31 30 3b 0a 0a 6d | 79 73 71 6c 3e 20 43 48 |Y=10;..m|ysql> CH|
|00004e00| 41 4e 47 45 20 4d 41 53 | 54 45 52 20 54 4f 0a 20 |ANGE MAS|TER TO. |
|00004e10| 20 20 20 2d 3e 20 20 20 | 20 20 52 45 4c 41 59 5f | -> | RELAY_|
|00004e20| 4c 4f 47 5f 46 49 4c 45 | 3d 27 73 6c 61 76 65 2d |LOG_FILE|='slave-|
|00004e30| 72 65 6c 61 79 2d 62 69 | 6e 2e 30 30 36 27 2c 0a |relay-bi|n.006',.|
|00004e40| 20 20 20 20 2d 3e 20 20 | 20 20 20 52 45 4c 41 59 | -> | RELAY|
|00004e50| 5f 4c 4f 47 5f 50 4f 53 | 3d 34 30 32 35 3b 0a 00 |_LOG_POS|=4025;..|
|00004e60| 03 00 e7 01 22 28 00 00 | 00 01 2a 0a 00 15 00 20 |...."(..|..*.... |
|00004e70| 20 20 2a 0a 4d 75 6c 74 | 69 70 6c 69 63 61 74 69 | *.Mult|iplicati|
|00004e80| 6f 6e 3a 0a c4 00 6d 79 | 73 71 6c 3e 20 53 45 4c |on:...my|sql> SEL|
|00004e90| 45 43 54 20 33 2a 35 3b | 0a 20 20 20 20 20 20 20 |ECT 3*5;|. |
|00004ea0| 20 2d 3e 20 31 35 0a 6d | 79 73 71 6c 3e 20 53 45 | -> 15.m|ysql> SE|
|00004eb0| 4c 45 43 54 20 31 38 30 | 31 34 33 39 38 35 30 39 |LECT 180|14398509|
|00004ec0| 34 38 31 39 38 34 2a 31 | 38 30 31 34 33 39 38 35 |481984*1|80143985|
|00004ed0| 30 39 34 38 31 39 38 34 | 2e 30 3b 0a 20 20 20 20 |09481984|.0;. |
|00004ee0| 20 20 20 20 2d 3e 20 33 | 32 34 35 31 38 35 35 33 | -> 3|24518553|
|00004ef0| 36 35 38 34 32 36 37 32 | 36 37 38 33 31 35 36 30 |65842672|67831560|
|00004f00| 32 30 35 37 36 32 35 36 | 2e 30 0a 6d 79 73 71 6c |20576256|.0.mysql|
|00004f10| 3e 20 53 45 4c 45 43 54 | 20 31 38 30 31 34 33 39 |> SELECT| 1801439|
|00004f20| 38 35 30 39 34 38 31 39 | 38 34 2a 31 38 30 31 34 |85094819|84*18014|
|00004f30| 33 39 38 35 30 39 34 38 | 31 39 38 34 3b 0a 20 20 |39850948|1984;. |
|00004f40| 20 20 20 20 20 20 2d 3e | 20 30 00 00 03 00 a0 00 | ->| 0......|
|00004f50| 22 29 00 00 00 05 52 54 | 52 49 4d 0b 00 59 00 20 |")....RT|RIM..Y. |
|00004f60| 20 20 52 54 52 49 4d 28 | 40 76 61 72 7b 73 74 72 | RTRIM(|@var{str|
|00004f70| 7d 29 0a 52 65 74 75 72 | 6e 73 20 74 68 65 20 73 |}).Retur|ns the s|
|00004f80| 74 72 69 6e 67 20 40 76 | 61 72 7b 73 74 72 7d 20 |tring @v|ar{str} |
|00004f90| 77 69 74 68 20 74 72 61 | 69 6c 69 6e 67 20 73 70 |with tra|iling sp|
|00004fa0| 61 63 65 20 63 68 61 72 | 61 63 74 65 72 73 20 72 |ace char|acters r|
|00004fb0| 65 6d 6f 76 65 64 2e 0a | 35 00 6d 79 73 71 6c 3e |emoved..|5.mysql>|
|00004fc0| 20 53 45 4c 45 43 54 20 | 52 54 52 49 4d 28 27 62 | SELECT |RTRIM('b|
|00004fd0| 61 72 62 61 72 20 20 20 | 27 29 3b 0a 20 20 20 20 |arbar |');. |
|00004fe0| 20 20 20 20 2d 3e 20 27 | 62 61 72 62 61 72 27 00 | -> '|barbar'.|
|00004ff0| 03 00 3c 00 22 2a 00 00 | 00 01 2b 0a 00 0f 00 20 |..<."*..|..+.... |
|00005000| 20 20 2b 0a 41 64 64 69 | 74 69 6f 6e 3a 0a 1f 00 | +.Addi|tion:...|
|00005010| 6d 79 73 71 6c 3e 20 53 | 45 4c 45 43 54 20 33 2b |mysql> S|ELECT 3+|
|00005020| 35 3b 0a 20 20 20 20 20 | 20 20 20 2d 3e 20 38 00 |5;. | -> 8.|
|00005030| 03 00 c4 00 22 2b 00 00 | 00 08 43 4f 41 4c 45 53 |...."+..|..COALES|
|00005040| 43 45 04 00 4b 00 20 20 | 20 43 4f 41 4c 45 53 43 |CE..K. | COALESC|
|00005050| 45 28 40 76 61 72 7b 76 | 61 6c 75 65 7d 2c 2e 2e |E(@var{v|alue},..|
|00005060| 2e 29 0a 52 65 74 75 72 | 6e 73 20 74 68 65 20 66 |.).Retur|ns the f|
|00005070| 69 72 73 74 20 6e 6f 6e | 2d 4e 55 4c 4c 20 76 61 |irst non|-NULL va|
|00005080| 6c 75 65 20 69 6e 20 74 | 68 65 20 6c 69 73 74 2e |lue in t|he list.|
|00005090| 0a 64 00 6d 79 73 71 6c | 3e 20 53 45 4c 45 43 54 |.d.mysql|> SELECT|
|000050a0| 20 43 4f 41 4c 45 53 43 | 45 28 4e 55 4c 4c 2c 31 | COALESC|E(NULL,1|
|000050b0| 29 3b 0a 20 20 20 20 20 | 20 20 20 2d 3e 20 31 0a |);. | -> 1.|
|000050c0| 6d 79 73 71 6c 3e 20 53 | 45 4c 45 43 54 20 43 4f |mysql> S|ELECT CO|
|000050d0| 41 4c 45 53 43 45 28 4e | 55 4c 4c 2c 4e 55 4c 4c |ALESCE(N|ULL,NULL|
|000050e0| 2c 4e 55 4c 4c 29 3b 0a | 20 20 20 20 20 20 20 20 |,NULL);.| |
|000050f0| 2d 3e 20 4e 55 4c 4c 00 | 03 00 74 00 32 2c 00 00 |-> NULL.|..t.2,..|
|00005100| 00 12 53 48 4f 57 20 4d | 41 53 54 45 52 20 53 54 |..SHOW M|ASTER ST|
|00005110| 41 54 55 53 1a 00 57 00 | 53 48 4f 57 20 4d 41 53 |ATUS..W.|SHOW MAS|
|00005120| 54 45 52 20 53 54 41 54 | 55 53 0a 0a 50 72 6f 76 |TER STAT|US..Prov|
|00005130| 69 64 65 73 20 73 74 61 | 74 75 73 20 69 6e 66 6f |ides sta|tus info|
|00005140| 72 6d 61 74 69 6f 6e 20 | 6f 6e 20 74 68 65 20 62 |rmation |on the b|
|00005150| 69 6e 61 72 79 20 6c 6f | 67 20 66 69 6c 65 73 20 |inary lo|g files |
|00005160| 6f 66 20 74 68 65 20 6d | 61 73 74 65 72 2e 0a 00 |of the m|aster...|
|00005170| 03 00 de 02 22 2d 00 00 | 00 03 4c 4f 47 0a 00 7e |...."-..|..LOG..~|
|00005180| 00 20 20 20 4c 4f 47 28 | 40 76 61 72 7b 58 7d 29 |. LOG(|@var{X})|
|00005190| 0a 20 20 20 4c 4f 47 28 | 40 76 61 72 7b 42 7d 2c |. LOG(|@var{B},|
|000051a0| 40 76 61 72 7b 58 7d 29 | 0a 49 66 20 63 61 6c 6c |@var{X})|.If call|
|000051b0| 65 64 20 77 69 74 68 20 | 6f 6e 65 20 70 61 72 61 |ed with |one para|
|000051c0| 6d 65 74 65 72 2c 20 74 | 68 69 73 20 66 75 6e 63 |meter, t|his func|
|000051d0| 74 69 6f 6e 20 72 65 74 | 75 72 6e 73 20 74 68 65 |tion ret|urns the|
|000051e0| 20 6e 61 74 75 72 61 6c | 20 6c 6f 67 61 72 69 74 | natural| logarit|
|000051f0| 68 6d 0a 6f 66 20 40 76 | 61 72 7b 58 7d 2e 0a 50 |hm.of @v|ar{X}..P|
|00005200| 00 6d 79 73 71 6c 3e 20 | 53 45 4c 45 43 54 20 4c |.mysql> |SELECT L|
|00005210| 4f 47 28 32 29 3b 0a 20 | 20 20 20 20 20 20 20 2d |OG(2);. | -|
|00005220| 3e 20 30 2e 36 39 33 31 | 34 37 0a 6d 79 73 71 6c |> 0.6931|47.mysql|
|00005230| 3e 20 53 45 4c 45 43 54 | 20 4c 4f 47 28 2d 32 29 |> SELECT| LOG(-2)|
|00005240| 3b 0a 20 20 20 20 20 20 | 20 20 2d 3e 20 4e 55 4c |;. | -> NUL|
|00005250| 4c 00 00 00 03 00 3f 01 | 22 2e 00 00 00 01 2f 0a |L.....?.|"...../.|
|00005260| 00 0f 00 20 20 20 2f 0a | 44 69 76 69 73 69 6f 6e |... /.|Division|
|00005270| 3a 0a 22 00 6d 79 73 71 | 6c 3e 20 53 45 4c 45 43 |:.".mysq|l> SELEC|
|00005280| 54 20 33 2f 35 3b 0a 20 | 20 20 20 20 20 20 20 2d |T 3/5;. | -|
|00005290| 3e 20 30 2e 36 30 00 00 | 01 03 e5 32 2f 00 00 00 |> 0.60..|...2/...|
|000052a0| 0b 52 45 53 45 54 20 53 | 4c 41 56 45 13 00 cf 03 |.RESET S|LAVE....|
|000052b0| 52 45 53 45 54 20 53 4c | 41 56 45 0a 0a 4d 61 6b |RESET SL|AVE..Mak|
|000052c0| 65 73 20 74 68 65 20 73 | 6c 61 76 65 20 66 6f 72 |es the s|lave for|
|000052d0| 67 65 74 20 69 74 73 20 | 72 65 70 6c 69 63 61 74 |get its |replicat|
|000052e0| 69 6f 6e 20 70 6f 73 69 | 74 69 6f 6e 20 69 6e 20 |ion posi|tion in |
|000052f0| 74 68 65 20 6d 61 73 74 | 65 72 27 73 20 62 69 6e |the mast|er's bin|
|00005300| 61 72 79 20 6c 6f 67 73 | 2e 0a 54 68 69 73 20 73 |ary logs|..This s|
|00005310| 74 61 74 65 6d 65 6e 74 | 20 69 73 20 6d 65 61 6e |tatement| is mean|
|00005320| 74 20 74 6f 20 62 65 20 | 75 73 65 64 20 66 6f 72 |t to be |used for|
|00005330| 20 61 20 63 6c 65 61 6e | 20 73 74 61 72 74 3a 20 | a clean| start: |
|00005340| 49 74 20 64 65 6c 65 74 | 65 73 20 74 68 65 0a 2a |It delet|es the.*|
|00005350| 6d 61 73 74 65 72 2e 69 | 6e 66 6f 20 61 6e 64 20 |master.i|nfo and |
|00005360| 2a 72 65 6c 61 79 2d 6c | 6f 67 2e 69 6e 66 6f 20 |*relay-l|og.info |
|00005370| 66 69 6c 65 73 2c 20 61 | 6c 6c 20 74 68 65 20 72 |files, a|ll the r|
|00005380| 65 6c 61 79 20 6c 6f 67 | 73 2c 0a 61 6e 64 20 73 |elay log|s,.and s|
|00005390| 74 61 72 74 73 20 61 20 | 6e 65 77 20 72 65 6c 61 |tarts a |new rela|
|000053a0| 79 20 6c 6f 67 2e 0a 0a | 4e 6f 74 65 3a 20 41 6c |y log...|Note: Al|
|000053b0| 6c 20 72 65 6c 61 79 20 | 6c 6f 67 73 20 61 72 65 |l relay |logs are|
|000053c0| 20 64 65 6c 65 74 65 64 | 2c 20 65 76 65 6e 20 69 | deleted|, even i|
|000053d0| 66 20 74 68 65 79 20 68 | 61 76 65 20 6e 6f 74 20 |f they h|ave not |
|000053e0| 62 65 65 6e 0a 74 6f 74 | 61 6c 6c 79 20 65 78 65 |been.tot|ally exe|
|000053f0| 63 75 74 65 64 20 62 79 | 20 74 68 65 20 73 6c 61 |cuted by| the sla|
|00005400| 76 65 20 53 51 4c 20 74 | 68 72 65 61 64 2e 20 20 |ve SQL t|hread. |
|00005410| 28 54 68 69 73 20 69 73 | 20 61 20 63 6f 6e 64 69 |(This is| a condi|
|00005420| 74 69 6f 6e 20 6c 69 6b | 65 6c 79 20 74 6f 0a 65 |tion lik|ely to.e|
|00005430| 78 69 73 74 20 6f 6e 20 | 61 20 72 65 70 6c 69 63 |xist on |a replic|
|00005440| 61 74 69 6f 6e 20 73 6c | 61 76 65 20 69 66 20 79 |ation sl|ave if y|
|00005450| 6f 75 20 68 61 76 65 20 | 69 73 73 75 65 64 20 61 |ou have |issued a|
|00005460| 20 53 54 4f 50 20 53 4c | 41 56 45 0a 73 74 61 74 | STOP SL|AVE.stat|
|00005470| 65 6d 65 6e 74 20 6f 72 | 20 69 66 20 74 68 65 20 |ement or| if the |
|00005480| 73 6c 61 76 65 20 69 73 | 20 68 69 67 68 6c 79 20 |slave is| highly |
|00005490| 6c 6f 61 64 65 64 2e 29 | 0a 0a 43 6f 6e 6e 65 63 |loaded.)|..Connec|
|000054a0| 74 69 6f 6e 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |tion inf|ormation|
|000054b0| 20 73 74 6f 72 65 64 20 | 69 6e 20 74 68 65 20 2a | stored |in the *|
|000054c0| 6d 61 73 74 65 72 2e 69 | 6e 66 6f 20 66 69 6c 65 |master.i|nfo file|
|000054d0| 20 69 73 20 69 6d 6d 65 | 64 69 61 74 65 6c 79 0a | is imme|diately.|
|000054e0| 72 65 73 65 74 20 75 73 | 69 6e 67 20 61 6e 79 20 |reset us|ing any |
|000054f0| 76 61 6c 75 65 73 20 73 | 70 65 63 69 66 69 65 64 |values s|pecified|
|00005500| 20 69 6e 20 74 68 65 20 | 63 6f 72 72 65 73 70 6f | in the |correspo|
|00005510| 6e 64 69 6e 67 20 73 74 | 61 72 74 75 70 20 6f 70 |nding st|artup op|
|00005520| 74 69 6f 6e 73 2e 0a 54 | 68 69 73 20 69 6e 66 6f |tions..T|his info|
|00005530| 72 6d 61 74 69 6f 6e 20 | 69 6e 63 6c 75 64 65 73 |rmation |includes|
|00005540| 20 76 61 6c 75 65 73 20 | 73 75 63 68 20 61 73 20 | values |such as |
|00005550| 6d 61 73 74 65 72 20 68 | 6f 73 74 2c 20 6d 61 73 |master h|ost, mas|
|00005560| 74 65 72 20 70 6f 72 74 | 2c 20 6d 61 73 74 65 72 |ter port|, master|
|00005570| 0a 75 73 65 72 2c 20 61 | 6e 64 20 6d 61 73 74 65 |.user, a|nd maste|
|00005580| 72 20 70 61 73 73 77 6f | 72 64 2e 20 20 49 66 20 |r passwo|rd. If |
|00005590| 74 68 65 20 73 6c 61 76 | 65 20 53 51 4c 20 74 68 |the slav|e SQL th|
|000055a0| 72 65 61 64 20 77 61 73 | 20 69 6e 20 74 68 65 20 |read was| in the |
|000055b0| 6d 69 64 64 6c 65 20 6f | 66 0a 72 65 70 6c 69 63 |middle o|f.replic|
|000055c0| 61 74 69 6e 67 20 74 65 | 6d 70 6f 72 61 72 79 20 |ating te|mporary |
|000055d0| 74 61 62 6c 65 73 20 77 | 68 65 6e 20 69 74 20 77 |tables w|hen it w|
|000055e0| 61 73 20 73 74 6f 70 70 | 65 64 2c 20 61 6e 64 20 |as stopp|ed, and |
|000055f0| 52 45 53 45 54 20 53 4c | 41 56 45 0a 69 73 20 69 |RESET SL|AVE.is i|
|00005600| 73 73 75 65 64 2c 20 74 | 68 65 73 65 20 72 65 70 |ssued, t|hese rep|
|00005610| 6c 69 63 61 74 65 64 20 | 74 65 6d 70 6f 72 61 72 |licated |temporar|
|00005620| 79 20 74 61 62 6c 65 73 | 20 61 72 65 20 64 65 6c |y tables| are del|
|00005630| 65 74 65 64 20 6f 6e 20 | 74 68 65 20 73 6c 61 76 |eted on |the slav|
|00005640| 65 2e 0a 0a 54 68 69 73 | 20 73 74 61 74 65 6d 65 |e...This| stateme|
|00005650| 6e 74 20 77 61 73 20 6e | 61 6d 65 64 20 46 4c 55 |nt was n|amed FLU|
|00005660| 53 48 20 53 4c 41 56 45 | 20 62 65 66 6f 72 65 20 |SH SLAVE| before |
|00005670| 4d 79 53 51 4c 20 33 2e | 32 33 2e 32 36 2e 0a 00 |MySQL 3.|23.26...|
|00005680| 03 00 88 00 32 30 00 00 | 00 0a 49 4e 54 45 52 53 |....20..|..INTERS|
|00005690| 45 43 54 53 19 00 73 00 | 20 20 20 49 6e 74 65 72 |ECTS..s.| Inter|
|000056a0| 73 65 63 74 73 28 40 76 | 61 72 7b 67 31 7d 2c 40 |sects(@v|ar{g1},@|
|000056b0| 76 61 72 7b 67 32 7d 29 | 0a 52 65 74 75 72 6e 73 |var{g2})|.Returns|
|000056c0| 20 31 20 6f 72 20 30 20 | 74 6f 20 69 6e 64 69 63 | 1 or 0 |to indic|
|000056d0| 61 74 65 20 77 68 65 74 | 68 65 72 20 6f 72 20 6e |ate whet|her or n|
|000056e0| 6f 74 20 40 76 61 72 7b | 67 31 7d 20 73 70 61 74 |ot @var{|g1} spat|
|000056f0| 69 61 6c 6c 79 20 69 6e | 74 65 72 73 65 63 74 73 |ially in|tersects|
|00005700| 0a 40 76 61 72 7b 67 32 | 7d 2e 0a 00 03 00 66 02 |.@var{g2|}.....f.|
|00005710| 22 31 00 00 00 02 3c 3c | 1c 00 35 00 20 20 20 3c |"1....<<|..5. <|
|00005720| 3c 0a 53 68 69 66 74 73 | 20 61 20 6c 6f 6e 67 6c |<.Shifts| a longl|
|00005730| 6f 6e 67 20 28 42 49 47 | 49 4e 54 29 20 6e 75 6d |ong (BIG|INT) num|
|00005740| 62 65 72 20 74 6f 20 74 | 68 65 20 6c 65 66 74 2e |ber to t|he left.|
|00005750| 0a 22 00 6d 79 73 71 6c | 3e 20 53 45 4c 45 43 54 |.".mysql|> SELECT|
|00005760| 20 31 20 3c 3c 20 32 3b | 0a 20 20 20 20 20 20 20 | 1 << 2;|. |
|00005770| 20 2d 3e 20 34 00 00 00 | 03 01 23 01 22 32 00 00 | -> 4...|..#."2..|
|00005780| 00 06 52 45 50 45 41 54 | 0b 00 d2 00 20 20 20 52 |..REPEAT|.... R|
|00005790| 45 50 45 41 54 28 40 76 | 61 72 7b 73 74 72 7d 2c |EPEAT(@v|ar{str},|
|000057a0| 40 76 61 72 7b 63 6f 75 | 6e 74 7d 29 0a 52 65 74 |@var{cou|nt}).Ret|
|000057b0| 75 72 6e 73 20 61 20 73 | 74 72 69 6e 67 20 63 6f |urns a s|tring co|
|000057c0| 6e 73 69 73 74 69 6e 67 | 20 6f 66 20 74 68 65 20 |nsisting| of the |
|000057d0| 73 74 72 69 6e 67 20 40 | 76 61 72 7b 73 74 72 7d |string @|var{str}|
|000057e0| 20 72 65 70 65 61 74 65 | 64 20 40 76 61 72 7b 63 | repeate|d @var{c|
|000057f0| 6f 75 6e 74 7d 0a 74 69 | 6d 65 73 2e 20 49 66 20 |ount}.ti|mes. If |
|00005800| 40 76 61 72 7b 63 6f 75 | 6e 74 20 3c 3d 20 30 7d |@var{cou|nt <= 0}|
|00005810| 2c 20 72 65 74 75 72 6e | 73 20 61 6e 20 65 6d 70 |, return|s an emp|
|00005820| 74 79 20 73 74 72 69 6e | 67 2e 20 52 65 74 75 72 |ty strin|g. Retur|
|00005830| 6e 73 20 4e 55 4c 4c 20 | 69 66 0a 40 76 61 72 7b |ns NULL |if.@var{|
|00005840| 73 74 72 7d 20 6f 72 20 | 40 76 61 72 7b 63 6f 75 |str} or |@var{cou|
|00005850| 6e 74 7d 20 61 72 65 20 | 4e 55 4c 4c 2e 0a 3e 00 |nt} are |NULL..>.|
|00005860| 6d 79 73 71 6c 3e 20 53 | 45 4c 45 43 54 20 52 45 |mysql> S|ELECT RE|
|00005870| 50 45 41 54 28 27 4d 79 | 53 51 4c 27 2c 20 33 29 |PEAT('My|SQL', 3)|
|00005880| 3b 0a 20 20 20 20 20 20 | 20 20 2d 3e 20 27 4d 79 |;. | -> 'My|
|00005890| 53 51 4c 4d 79 53 51 4c | 4d 79 53 51 4c 27 00 00 |SQLMySQL|MySQL'..|
|000058a0| 01 00 4d 22 33 00 00 00 | 02 3c 3d 04 00 1a 00 20 |..M"3...|.<=.... |
|000058b0| 20 20 3c 3d 0a 4c 65 73 | 73 20 74 68 61 6e 20 6f | <=.Les|s than o|
|000058c0| 72 20 65 71 75 61 6c 3a | 0a 24 00 6d 79 73 71 6c |r equal:|.$.mysql|
|000058d0| 3e 20 53 45 4c 45 43 54 | 20 30 2e 31 20 3c 3d 20 |> SELECT| 0.1 <= |
|000058e0| 32 3b 0a 20 20 20 20 20 | 20 20 20 2d 3e 20 31 00 |2;. | -> 1.|
|000058f0| 03 02 a7 01 32 34 00 00 | 00 16 4c 4f 41 44 20 54 |....24..|..LOAD T|
|00005900| 41 42 4c 45 20 46 52 4f | 4d 20 4d 41 53 54 45 52 |ABLE FRO|M MASTER|
|00005910| 1a 00 86 02 4c 4f 41 44 | 20 54 41 42 4c 45 20 40 |....LOAD| TABLE @|
|00005920| 76 61 72 7b 74 62 6c 5f | 6e 61 6d 65 7d 20 46 52 |var{tbl_|name} FR|
|00005930| 4f 4d 20 4d 41 53 54 45 | 52 0a 0a 54 72 61 6e 73 |OM MASTE|R..Trans|
|00005940| 66 65 72 73 20 61 20 63 | 6f 70 79 20 6f 66 20 74 |fers a c|opy of t|
|00005950| 68 65 20 74 61 62 6c 65 | 20 66 72 6f 6d 20 6d 61 |he table| from ma|
|00005960| 73 74 65 72 20 74 6f 20 | 74 68 65 20 73 6c 61 76 |ster to |the slav|
|00005970| 65 2e 20 54 68 69 73 20 | 73 74 61 74 65 6d 65 6e |e. This |statemen|
|00005980| 74 20 69 73 0a 69 6d 70 | 6c 65 6d 65 6e 74 65 64 |t is.imp|lemented|
|00005990| 20 6d 61 69 6e 6c 79 20 | 66 6f 72 20 64 65 62 75 | mainly |for debu|
|000059a0| 67 67 69 6e 67 20 6f 66 | 20 4c 4f 41 44 20 44 41 |gging of| LOAD DA|
|000059b0| 54 41 20 46 52 4f 4d 20 | 4d 41 53 54 45 52 2e 0a |TA FROM |MASTER..|
|000059c0| 49 74 20 72 65 71 75 69 | 72 65 73 20 74 68 61 74 |It requi|res that|
|000059d0| 20 74 68 65 20 61 63 63 | 6f 75 6e 74 20 75 73 65 | the acc|ount use|
|000059e0| 64 20 66 6f 72 20 63 6f | 6e 6e 65 63 74 69 6e 67 |d for co|nnecting|
|000059f0| 20 74 6f 20 74 68 65 20 | 6d 61 73 74 65 72 20 73 | to the |master s|
|00005a00| 65 72 76 65 72 20 68 61 | 73 20 74 68 65 0a 52 45 |erver ha|s the.RE|
|00005a10| 4c 4f 41 44 20 61 6e 64 | 20 53 55 50 45 52 20 70 |LOAD and| SUPER p|
|00005a20| 72 69 76 69 6c 65 67 65 | 73 20 6f 6e 20 74 68 65 |rivilege|s on the|
|00005a30| 20 6d 61 73 74 65 72 20 | 61 6e 64 20 74 68 65 0a | master |and the.|
|00005a40| 53 45 4c 45 43 54 20 70 | 72 69 76 69 6c 65 67 65 |SELECT p|rivilege|
|00005a50| 20 6f 6e 20 74 68 65 20 | 6d 61 73 74 65 72 20 74 | on the |master t|
|00005a60| 61 62 6c 65 20 74 6f 20 | 6c 6f 61 64 2e 0a 4f 6e |able to |load..On|
|00005a70| 20 74 68 65 20 73 6c 61 | 76 65 20 73 69 64 65 2c | the sla|ve side,|
|00005a80| 20 74 68 65 20 75 73 65 | 72 20 74 68 61 74 20 69 | the use|r that i|
|00005a90| 73 73 75 65 73 20 4c 4f | 41 44 20 54 41 42 4c 45 |ssues LO|AD TABLE|
|00005aa0| 20 46 52 4f 4d 20 4d 41 | 53 54 45 52 20 73 68 6f | FROM MA|STER sho|
|00005ab0| 75 6c 64 0a 68 61 76 65 | 20 70 72 69 76 69 6c 65 |uld.have| privile|
|00005ac0| 67 65 73 20 74 6f 20 64 | 72 6f 70 20 61 6e 64 20 |ges to d|rop and |
|00005ad0| 63 72 65 61 74 65 20 74 | 68 65 20 74 61 62 6c 65 |create t|he table|
|00005ae0| 2e 0a 0a 54 68 65 20 63 | 6f 6e 64 69 74 69 6f 6e |...The c|ondition|
|00005af0| 73 20 66 6f 72 20 4c 4f | 41 44 20 44 41 54 41 20 |s for LO|AD DATA |
|00005b00| 46 52 4f 4d 20 4d 41 53 | 54 45 52 20 61 70 70 6c |FROM MAS|TER appl|
|00005b10| 79 20 68 65 72 65 2c 20 | 74 6f 6f 2e 20 46 6f 72 |y here, |too. For|
|00005b20| 0a 65 78 61 6d 70 6c 65 | 2c 20 4c 4f 41 44 20 54 |.example|, LOAD T|
|00005b30| 41 42 4c 45 20 46 52 4f | 4d 20 4d 41 53 54 45 52 |ABLE FRO|M MASTER|
|00005b40| 20 77 6f 72 6b 73 20 6f | 6e 6c 79 20 66 6f 72 20 | works o|nly for |
|00005b50| 4d 79 49 53 41 4d 20 74 | 61 62 6c 65 73 2e 0a 54 |MyISAM t|ables..T|
|00005b60| 68 65 20 74 69 6d 65 6f | 75 74 20 6e 6f 74 65 73 |he timeo|ut notes|
|00005b70| 20 66 6f 72 20 4c 4f 41 | 44 20 44 41 54 41 20 46 | for LOA|D DATA F|
|00005b80| 52 4f 4d 20 4d 41 53 54 | 45 52 20 61 70 70 6c 79 |ROM MAST|ER apply|
|00005b90| 20 61 73 20 77 65 6c 6c | 2e 0a 00 00 03 01 07 01 | as well|........|
|00005ba0| 32 35 00 00 00 0b 54 49 | 4d 45 5f 46 4f 52 4d 41 |25....TI|ME_FORMA|
|00005bb0| 54 0f 00 f1 00 20 20 20 | 54 49 4d 45 5f 46 4f 52 |T.... |TIME_FOR|
|00005bc0| 4d 41 54 28 40 76 61 72 | 7b 74 69 6d 65 7d 2c 40 |MAT(@var|{time},@|
|00005bd0| 76 61 72 7b 66 6f 72 6d | 61 74 7d 29 0a 54 68 69 |var{form|at}).Thi|
|00005be0| 73 20 69 73 20 75 73 65 | 64 20 6c 69 6b 65 20 74 |s is use|d like t|
|00005bf0| 68 65 20 44 41 54 45 5f | 46 4f 52 4d 41 54 28 29 |he DATE_|FORMAT()|
|00005c00| 20 66 75 6e 63 74 69 6f | 6e 2c 20 62 75 74 20 74 | functio|n, but t|
|00005c10| 68 65 0a 40 76 61 72 7b | 66 6f 72 6d 61 74 7d 20 |he.@var{|format} |
|00005c20| 73 74 72 69 6e 67 20 6d | 61 79 20 63 6f 6e 74 61 |string m|ay conta|
|00005c30| 69 6e 20 6f 6e 6c 79 20 | 74 68 6f 73 65 20 66 6f |in only |those fo|
|00005c40| 72 6d 61 74 20 73 70 65 | 63 69 66 69 65 72 73 20 |rmat spe|cifiers |
|00005c50| 74 68 61 74 20 68 61 6e | 64 6c 65 0a 68 6f 75 72 |that han|dle.hour|
|00005c60| 73 2c 20 6d 69 6e 75 74 | 65 73 2c 20 61 6e 64 20 |s, minut|es, and |
|00005c70| 73 65 63 6f 6e 64 73 2e | 20 20 4f 74 68 65 72 20 |seconds.| Other |
|00005c80| 73 70 65 63 69 66 69 65 | 72 73 20 70 72 6f 64 75 |specifie|rs produ|
|00005c90| 63 65 20 61 20 4e 55 4c | 4c 20 76 61 6c 75 65 20 |ce a NUL|L value |
|00005ca0| 6f 72 0a 30 2e 0a 00 00 | 03 01 22 02 32 36 00 00 |or.0....|..".26..|
|00005cb0| 00 0b 43 48 41 52 5f 4c | 45 4e 47 54 48 0b 00 0c |..CHAR_L|ENGTH...|
|00005cc0| 01 20 20 20 43 48 41 52 | 5f 4c 45 4e 47 54 48 28 |. CHAR|_LENGTH(|
|00005cd0| 40 76 61 72 7b 73 74 72 | 7d 29 0a 0a 52 65 74 75 |@var{str|})..Retu|
|00005ce0| 72 6e 73 20 74 68 65 20 | 6c 65 6e 67 74 68 20 6f |rns the |length o|
|00005cf0| 66 20 74 68 65 20 73 74 | 72 69 6e 67 20 40 76 61 |f the st|ring @va|
|00005d00| 72 7b 73 74 72 7d 2c 20 | 6d 65 61 73 75 72 65 64 |r{str}, |measured|
|00005d10| 20 69 6e 20 63 68 61 72 | 61 63 74 65 72 73 2e 0a | in char|acters..|
|00005d20| 41 20 6d 75 6c 74 69 2d | 62 79 74 65 20 63 68 61 |A multi-|byte cha|
|00005d30| 72 61 63 74 65 72 20 63 | 6f 75 6e 74 73 20 61 73 |racter c|ounts as|
|00005d40| 20 61 20 73 69 6e 67 6c | 65 20 63 68 61 72 61 63 | a singl|e charac|
|00005d50| 74 65 72 2e 0a 54 68 69 | 73 20 6d 65 61 6e 73 20 |ter..Thi|s means |
|00005d60| 74 68 61 74 20 66 6f 72 | 20 61 20 73 74 72 69 6e |that for| a strin|
|00005d70| 67 20 63 6f 6e 74 61 69 | 6e 69 6e 67 20 66 69 76 |g contai|ning fiv|
|00005d80| 65 20 74 77 6f 2d 62 79 | 74 65 20 63 68 61 72 61 |e two-by|te chara|
|00005d90| 63 74 65 72 73 2c 0a 4c | 45 4e 47 54 48 28 29 20 |cters,.L|ENGTH() |
|00005da0| 72 65 74 75 72 6e 73 20 | 31 30 2c 20 77 68 65 72 |returns |10, wher|
|00005db0| 65 61 73 20 43 48 41 52 | 5f 4c 45 4e 47 54 48 28 |eas CHAR|_LENGTH(|
|00005dc0| 29 20 72 65 74 75 72 6e | 73 0a 35 2e 0a 00 00 00 |) return|s.5.....|
|00005dd0| 03 00 52 02 2a 37 00 00 | 00 08 50 41 53 53 57 4f |..R.*7..|..PASSWO|
|00005de0| 52 44 08 00 3f 00 6d 79 | 73 71 6c 3e 20 53 45 4c |RD..?.my|sql> SEL|
|00005df0| 45 43 54 20 50 41 53 53 | 57 4f 52 44 28 27 62 61 |ECT PASS|WORD('ba|
|00005e00| 64 70 77 64 27 29 3b 0a | 20 20 20 20 20 20 20 20 |dpwd');.| |
|00005e10| 2d 3e 20 27 37 66 38 34 | 35 35 34 30 35 37 64 64 |-> '7f84|554057dd|
|00005e20| 39 36 34 62 27 00 00 00 | 03 00 3f 01 22 38 00 00 |964b'...|..?."8..|
|00005e30| 00 01 3c 04 00 10 00 20 | 20 20 3c 0a 4c 65 73 73 |..<.... | <.Less|
|00005e40| 20 74 68 61 6e 3a 0a 21 | 00 6d 79 73 71 6c 3e 20 | than:.!|.mysql> |
|00005e50| 53 45 4c 45 43 54 20 32 | 20 3c 20 32 3b 0a 20 20 |SELECT 2| < 2;. |
|00005e60| 20 20 20 20 20 20 2d 3e | 20 30 00 00 01 00 d5 22 | ->| 0....."|
|00005e70| 39 00 00 00 01 3d 04 00 | 0c 00 20 20 20 3d 0a 45 |9....=..|.. =.E|
|00005e80| 71 75 61 6c 3a 0a bb 00 | 6d 79 73 71 6c 3e 20 53 |qual:...|mysql> S|
|00005e90| 45 4c 45 43 54 20 31 20 | 3d 20 30 3b 0a 20 20 20 |ELECT 1 |= 0;. |
|00005ea0| 20 20 20 20 20 2d 3e 20 | 30 0a 6d 79 73 71 6c 3e | -> |0.mysql>|
|00005eb0| 20 53 45 4c 45 43 54 20 | 27 30 27 20 3d 20 30 3b | SELECT |'0' = 0;|
|00005ec0| 0a 20 20 20 20 20 20 20 | 20 2d 3e 20 31 0a 6d 79 |. | -> 1.my|
|00005ed0| 73 71 6c 3e 20 53 45 4c | 45 43 54 20 27 30 2e 30 |sql> SEL|ECT '0.0|
|00005ee0| 27 20 3d 20 30 3b 0a 20 | 20 20 20 20 20 20 20 2d |' = 0;. | -|
|00005ef0| 3e 20 31 0a 6d 79 73 71 | 6c 3e 20 53 45 4c 45 43 |> 1.mysq|l> SELEC|
|00005f00| 54 20 27 30 2e 30 31 27 | 20 3d 20 30 3b 0a 20 20 |T '0.01'| = 0;. |
|00005f10| 20 20 20 20 20 20 2d 3e | 20 30 0a 6d 79 73 71 6c | ->| 0.mysql|
|00005f20| 3e 20 53 45 4c 45 43 54 | 20 27 2e 30 31 27 20 3d |> SELECT| '.01' =|
|00005f30| 20 30 2e 30 31 3b 0a 20 | 20 20 20 20 20 20 20 2d | 0.01;. | -|
|00005f40| 3e 20 31 00 03 00 42 02 | 22 3a 00 00 00 01 3e 04 |> 1...B.|":....>.|
|00005f50| 00 13 00 20 20 20 3e 0a | 47 72 65 61 74 65 72 20 |... >.|Greater |
|00005f60| 74 68 61 6e 3a 0a 21 00 | 6d 79 73 71 6c 3e 20 53 |than:.!.|mysql> S|
|00005f70| 45 4c 45 43 54 20 32 20 | 3e 20 32 3b 0a 20 20 20 |ELECT 2 |> 2;. |
|00005f80| 20 20 20 20 20 2d 3e 20 | 30 00 00 00 03 00 df 01 | -> |0.......|
|00005f90| 32 3b 00 00 00 07 49 53 | 45 4d 50 54 59 0d 00 cd |2;....IS|EMPTY...|
|00005fa0| 00 20 20 20 49 73 45 6d | 70 74 79 28 40 76 61 72 |. IsEm|pty(@var|
|00005fb0| 7b 67 7d 29 0a 52 65 74 | 75 72 6e 73 20 31 20 69 |{g}).Ret|urns 1 i|
|00005fc0| 66 20 74 68 65 20 67 65 | 6f 6d 65 74 72 79 20 76 |f the ge|ometry v|
|00005fd0| 61 6c 75 65 20 40 76 61 | 72 7b 67 7d 20 69 73 20 |alue @va|r{g} is |
|00005fe0| 74 68 65 20 65 6d 70 74 | 79 20 67 65 6f 6d 65 74 |the empt|y geomet|
|00005ff0| 72 79 2c 20 30 20 69 66 | 20 69 74 20 69 73 20 6e |ry, 0 if| it is n|
|00006000| 6f 74 0a 65 6d 70 74 79 | 2c 20 61 6e 64 20 40 6d |ot.empty|, and @m|
|00006010| 69 6e 75 73 7b 7d 31 20 | 69 66 20 74 68 65 20 61 |inus{}1 |if the a|
|00006020| 72 67 75 6d 65 6e 74 20 | 69 73 20 4e 55 4c 4c 2e |rgument |is NULL.|
|00006030| 0a 49 66 20 74 68 65 20 | 67 65 6f 6d 65 74 72 79 |.If the |geometry|
|00006040| 20 69 73 20 65 6d 70 74 | 79 2c 20 69 74 20 72 65 | is empt|y, it re|
|00006050| 70 72 65 73 65 6e 74 73 | 20 74 68 65 20 65 6d 70 |presents| the emp|
|00006060| 74 79 20 70 6f 69 6e 74 | 20 73 65 74 2e 0a 00 00 |ty point| set....|
|00006070| 03 00 8f 01 22 3c 00 00 | 00 03 41 42 53 0a 00 37 |...."<..|..ABS..7|
|00006080| 00 20 20 20 41 42 53 28 | 40 76 61 72 7b 58 7d 29 |. ABS(|@var{X})|
|00006090| 0a 52 65 74 75 72 6e 73 | 20 74 68 65 20 61 62 73 |.Returns| the abs|
|000060a0| 6f 6c 75 74 65 20 76 61 | 6c 75 65 20 6f 66 20 40 |olute va|lue of @|
|000060b0| 76 61 72 7b 58 7d 2e 0a | 48 00 6d 79 73 71 6c 3e |var{X}..|H.mysql>|
|000060c0| 20 53 45 4c 45 43 54 20 | 41 42 53 28 32 29 3b 0a | SELECT |ABS(2);.|
|000060d0| 20 20 20 20 20 20 20 20 | 2d 3e 20 32 0a 6d 79 73 | |-> 2.mys|
|000060e0| 71 6c 3e 20 53 45 4c 45 | 43 54 20 41 42 53 28 2d |ql> SELE|CT ABS(-|
|000060f0| 33 32 29 3b 0a 20 20 20 | 20 20 20 20 20 2d 3e 20 |32);. | -> |
|00006100| 33 32 00 00 03 00 47 01 | 32 3d 00 00 00 05 4c 43 |32....G.|2=....LC|
|00006110| 41 53 45 0b 00 37 00 20 | 20 20 4c 43 41 53 45 28 |ASE..7. | LCASE(|
|00006120| 40 76 61 72 7b 73 74 72 | 7d 29 0a 0a 4c 43 41 53 |@var{str|})..LCAS|
|00006130| 45 28 29 20 69 73 20 61 | 20 73 79 6e 6f 6e 79 6d |E() is a| synonym|
|00006140| 20 66 6f 72 20 4c 4f 57 | 45 52 28 29 2e 0a 00 00 | for LOW|ER()....|
|00006150| 01 04 7d 32 3e 00 00 00 | 04 53 48 4f 57 13 00 6e |..}2>...|.SHOW..n|
|00006160| 04 0a 53 45 54 20 61 6c | 6c 6f 77 73 20 79 6f 75 |..SET al|lows you|
|00006170| 20 74 6f 20 73 65 74 20 | 76 61 72 69 61 62 6c 65 | to set |variable|
|00006180| 73 20 61 6e 64 20 6f 70 | 74 69 6f 6e 73 2e 0a 0a |s and op|tions...|
|00006190| 53 48 4f 57 20 68 61 73 | 20 6d 61 6e 79 20 66 6f |SHOW has| many fo|
|000061a0| 72 6d 73 20 74 68 61 74 | 20 70 72 6f 76 69 64 65 |rms that| provide|
|000061b0| 20 69 6e 66 6f 72 6d 61 | 74 69 6f 6e 20 61 62 6f | informa|tion abo|
|000061c0| 75 74 20 64 61 74 61 62 | 61 73 65 73 2c 0a 74 61 |ut datab|ases,.ta|
|000061d0| 62 6c 65 73 2c 20 63 6f | 6c 75 6d 6e 73 2c 20 6f |bles, co|lumns, o|
|000061e0| 72 20 73 74 61 74 75 73 | 20 69 6e 66 6f 72 6d 61 |r status| informa|
|000061f0| 74 69 6f 6e 20 61 62 6f | 75 74 20 74 68 65 20 73 |tion abo|ut the s|
|00006200| 65 72 76 65 72 2e 0a 54 | 68 69 73 20 73 65 63 74 |erver..T|his sect|
|00006210| 69 6f 6e 20 64 65 73 63 | 72 69 62 65 73 20 74 68 |ion desc|ribes th|
|00006220| 6f 73 65 20 66 6f 6c 6c | 6f 77 69 6e 67 3a 0a 0a |ose foll|owing:..|
|00006230| 53 48 4f 57 20 5b 46 55 | 4c 4c 5d 20 43 4f 4c 55 |SHOW [FU|LL] COLU|
|00006240| 4d 4e 53 20 46 52 4f 4d | 20 40 76 61 72 7b 74 62 |MNS FROM| @var{tb|
|00006250| 6c 5f 6e 61 6d 65 7d 20 | 5b 46 52 4f 4d 20 40 76 |l_name} |[FROM @v|
|00006260| 61 72 7b 64 62 5f 6e 61 | 6d 65 7d 5d 20 5b 4c 49 |ar{db_na|me}] [LI|
|00006270| 4b 45 20 27 40 76 61 72 | 7b 70 61 74 74 65 72 6e |KE '@var|{pattern|
|00006280| 7d 27 5d 0a 53 48 4f 57 | 20 43 52 45 41 54 45 20 |}'].SHOW| CREATE |
|00006290| 44 41 54 41 42 41 53 45 | 20 40 76 61 72 7b 64 62 |DATABASE| @var{db|
|000062a0| 5f 6e 61 6d 65 7d 0a 53 | 48 4f 57 20 43 52 45 41 |_name}.S|HOW CREA|
|000062b0| 54 45 20 54 41 42 4c 45 | 20 40 76 61 72 7b 74 62 |TE TABLE| @var{tb|
|000062c0| 6c 5f 6e 61 6d 65 7d 0a | 53 48 4f 57 20 44 41 54 |l_name}.|SHOW DAT|
|000062d0| 41 42 41 53 45 53 20 5b | 4c 49 4b 45 20 27 40 76 |ABASES [|LIKE '@v|
|000062e0| 61 72 7b 70 61 74 74 65 | 72 6e 7d 27 5d 0a 53 48 |ar{patte|rn}'].SH|
|000062f0| 4f 57 20 5b 53 54 4f 52 | 41 47 45 5d 20 45 4e 47 |OW [STOR|AGE] ENG|
|00006300| 49 4e 45 53 0a 53 48 4f | 57 20 45 52 52 4f 52 53 |INES.SHO|W ERRORS|
|00006310| 20 5b 4c 49 4d 49 54 20 | 5b 40 76 61 72 7b 6f 66 | [LIMIT |[@var{of|
|00006320| 66 73 65 74 7d 2c 5d 20 | 40 76 61 72 7b 72 6f 77 |fset},] |@var{row|
|00006330| 5f 63 6f 75 6e 74 7d 5d | 0a 53 48 4f 57 20 47 52 |_count}]|.SHOW GR|
|00006340| 41 4e 54 53 20 46 4f 52 | 20 40 76 61 72 7b 75 73 |ANTS FOR| @var{us|
|00006350| 65 72 7d 0a 53 48 4f 57 | 20 49 4e 44 45 58 20 46 |er}.SHOW| INDEX F|
|00006360| 52 4f 4d 20 40 76 61 72 | 7b 74 62 6c 5f 6e 61 6d |ROM @var|{tbl_nam|
|00006370| 65 7d 20 5b 46 52 4f 4d | 20 40 76 61 72 7b 64 62 |e} [FROM| @var{db|
|00006380| 5f 6e 61 6d 65 7d 5d 0a | 53 48 4f 57 20 49 4e 4e |_name}].|SHOW INN|
|00006390| 4f 44 42 20 53 54 41 54 | 55 53 0a 53 48 4f 57 20 |ODB STAT|US.SHOW |
|000063a0| 5b 42 44 42 5d 20 4c 4f | 47 53 0a 53 48 4f 57 20 |[BDB] LO|GS.SHOW |
|000063b0| 50 52 49 56 49 4c 45 47 | 45 53 0a 53 48 4f 57 20 |PRIVILEG|ES.SHOW |
|000063c0| 5b 46 55 4c 4c 5d 20 50 | 52 4f 43 45 53 53 4c 49 |[FULL] P|ROCESSLI|
|000063d0| 53 54 0a 53 48 4f 57 20 | 53 54 41 54 55 53 20 5b |ST.SHOW |STATUS [|
|000063e0| 4c 49 4b 45 20 27 40 76 | 61 72 7b 70 61 74 74 65 |LIKE '@v|ar{patte|
|000063f0| 72 6e 7d 27 5d 0a 53 48 | 4f 57 20 54 41 42 4c 45 |rn}'].SH|OW TABLE|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
